Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unhappy Unanswered: DoCmd.TransferText and schema.ini

    I am attempting to export a MS Access table in VB using the DoCmd.TransferText method. Unfortunately, I have been unable to get the method to recognize the delimiter I wich to use between the fields (e.g., '|').

    I have tried defining a specification in the database prior and then executing the method using the following:

    DoCmd.TransferText TransferType:=acExportDelim, _
    SpecificationName:="tblEquipmentExportSpec", _
    TableName:="tblEquipment", _
    FileName:=ASCIIName_pc, _

    Unfortunately, the specification name isn't recognized, so I tried doing away with the specification name, and generating a schema.ini file which is ignored.

    What do I need to do to get the specification recognized?


  2. #2
    Join Date
    Oct 2001
    Add an extension to your filename and your code will work fine assuming the names match your objects.

Posting Permissions

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