Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Exporting a RS to excel?

    Can i export my rs to an excel file? and have it open like a table view??


    M~

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Cool

    You can use the following

    DoCmd.OutputTo acOutputTable, yrTableName , acFormatXLS, yrPath & yrFileName & ".xls"


    then you have to link this file to the access, then you will be able to see it as a table


    DoCmd.TransferDatabase acLink, "Microsoft Access", _
    txt_LinkPath & "\" & yrFileName, acTable, _
    yrSourceTableName, _
    yrDestinationTableName




Posting Permissions

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