fixedwidth conversion error when used in macro/schema.ini

A

Alan

I have a simple fixed width .txt file.
I can import it interactively and i can create an Import
Specificaton that also works when i run it interactively.

However when i use the Import Specification as an argument
to TransferText in a macro (appAccess.DoCmd.TransferText
acImportFixed, "Table3 Import Specification", ThisTable,
ThisTextFilePath, False) all rows are rejected with a Type
Conversion error.

Any suggestions appreciated.

Some documentaion refers to creating the Import
Specification via a schema.ini file - i'd try this but
can't find any information on how to create a schema.ini?

Thanks , Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing a text file with a schema.ini file 6
schema.ini files 4
DoCmd.TransferText error with Schema.ini import specification 5
Import using schema.ini file 1
I can't specify the Specification Name when use transfertext 1
Importing text with TransferText. It can't see my Schema.ini file 1
Schema.ini woes - field problems.... 11
Export Fixed With 5

Top