Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export ro Excel (2000)

    I'm doing a course for college & a part of one of the assignments is to export data to an Excel file. Now I know this is easy, from the appropriate menu command. But what I'd like to do is just put a button on a menu page that would do this. There are a total of 4 tables that would need tackling.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export ro Excel (2000)

    You can use someting like this in the on click event of your button: <pre>DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "YourTable", _
    "C:FileName.xls", True,"YourRange"
    </pre>

    Repeat the line for each table you want to export.
    Francois

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export ro Excel (2000)

    Thank you Francois, that's done the trick

Posting Permissions

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