Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    London,UK
    Posts
    54

    Unanswered: access export to excel

    i have a access db and am making a front end to it. on one of the screens i would like users to export the data held in a list box to an excel file so they can use and manipulate it for further statistics.

    lstResults.rowsource = sqlString

    just need to starting point on how to create an excel file in access and how to add data to columns and rows?

    any help much appreciated.

    thankx in advance peeps

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can use the OutPutTo like this:


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

Posting Permissions

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