Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    5

    Red face Unanswered: Unable to Export

    I'm want to use an export specification file with VB. Does anyone know how it works I can't figure it out. So far I have:
    DoCmd.TransferText acExportDelim, "ExportSpec.txt", "TableForEx", "c:\ExportResults.txt", False
    When I try and run this I get "The text file specification 'ExportSpec.txt' does not exist."

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    You create an Export specification by running the Export wizard and saving your choices. To do this, highlight the table you want to export and select File | Export. Go through the wizard screens including the Advanced. This is the screen that allows you to save the specification. The name you choose is used in the DoCmd.TransferText statement.
    Roger Hampson
    XI - ecs (UK) Ltd

Posting Permissions

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