Results 1 to 2 of 2
  1. #1
    tigers is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2006
    Posts
    28

    I saw this done before but don't remember how and where...

    to start.



    We used an access database to compile all of our general ledger accounts and balances. then, by pressing a button, an already existing spreadsheet which was our financial report would be automatically populated with the numbers in the database. The cells in the spreadsheet were spread out all over the spreadsheet so each field in the database would have to be referenced to a specific spreadsheet cell number somehow.

    Do you know what the function is that I need to use? Is it TransferSpreadsheet? Where do I start? Thanks!

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    You would use TransferSpreadsheet to export an Access object, such as a query result set or a table, to Excel.

    For what you are describing, it sounds more like you would want to open a recordset in code, substantiate an Excel.Application object, and then through that object populate ranges in a worksheet with values from the recordset.

    Can you be a little more specific about what you need to do?

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums