Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    Exporting RECORDs to Excel (Access 97 SR2)

    Is it possible to extract records from a table into an Excel workbook and have each record create a worksheet within that workbook?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts

    Re: Exporting RECORDs to Excel (Access 97 SR2)

    Yes it is - I would use OLE Automation to do it. The "transfer spreadsheet" command takes a table and converts it into a worksheet in Excel, so it won't do what you are after. A good reference on OLE Automation is The Access Developer's Handbook by Ken Getz, et. al. There is a specific example of working between Access and Excel in it. There are also several "How To" articles on the MS Knowledge Base, and there are several recent threads that touched on some of the issues. To be effective at it you should know a fair bit about using VBA both with Excel and with Access. Hope this helps.

Posting Permissions

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