Exporting with TransferText and schema.ini
Posted on 2004-08-25
I am sure this problem has been raised before. I am trying to do an export of a table using transferText. I need it to be tab delimited so I am creating a schema.ini just before the transfertext call.
DoCmd.TransferText acExportFixed, , "tempSubTestScoresExp", fileName, True, "", 437
I get an error when I leave out a spec argument and also when I put the path and name of schema.ini....what gives? I read that this is a known problem, but can't understand any of the workarounds given. Can someone help me out???