Results 1 to 5 of 5

Thread: Export to Excel

  1. #1
    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 Attached Files

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    596
    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

  3. #3
    Join Date
    Jan 2012
    Posts
    81
    Understood Tubbritt, thanks!

  4. #4
    Join Date
    Jul 2012
    Posts
    87
    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.

  5. #5
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •