If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Brilliant Database > Export to Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2012
Posts: 81
Export to Excel

Hi guys,

I will like to export to an excel document to create a report for a year period. There are 12 sheets January to December with headings that will relate to the fields i will like to pull from the database for specific customer (ASHLAND TRINIDAD & TOBAGO LIMITED).

The field in the database i will be using to reference the date for jobs is [created] with the label 'RECEIVED DATE-TIME'. This means jobs created for january when i export to the excel document will fall on the sheet january and so on. So if for example i am in the month of March and updated information in the database for the month of February it must be shown when i export to the excel sheet no matter what month i am currently in.

I will just like to press a button if possible that will export updated information from the database to the fields in the excel document respective to the month when it was created ([created] field). IF a table can be created with lines in the excel sheet as a new job is added will be nice too. Also i don't want the header to scroll down.

Anyone please?
Attached Files
File Type: zip DB-excel.zip (824.2 KB, 9 views)
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Location: Ireland
Posts: 547
Brilliant Database cannot drop data into a very specific cell within an excel file.

The only think I can think of right now is that if you created a new sheet inside your excel file called “import” and in row 1 you add the titles to each column.

Brilliant Database can populate this kind of layout.

So you will have to use a macro or a formula within excel to sort this data to the cells you want inside excel.

Maybe someone else will have a better way, but that's all I can come up with right now.

Regards
James
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2012
Posts: 81
Understood Tubbritt, thanks!
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 81
Tubbritt's true what he say.
Why you need this in excel.
I alway create report in BD and print it with Bullzip PDF printer to save my computer.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2012
Posts: 81
The reason really was to keep track of missing data...but i will do as you guys say! thanks again!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On