Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    Toronto, Canada
    Posts
    18

    Angry Unanswered: Export Access97 To Excel

    I need some help in exporting Access97 queries to Excel. When I use

    'DoCmd.OutputTo acOutputTable, yourTableName, acFormatXLS, _ yourPathAndFileName& ".xls"

    the file is exported but the header is not the column name. It is coming up as Field1, Field2 and so on.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    You should look at DoCmd.TransferSpreadsheet in the help.

  3. #3
    Join Date
    Feb 2003
    Location
    Toronto, Canada
    Posts
    18

    Talking EXPORT ACCESS TO EXCEL

    Thanks works okay.

Posting Permissions

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