Docmd.TransferText question

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-06-07T00:08:04Z Indexed on 2010/06/07 0:12 UTC
Read the original article Hit count: 139

Filed under:
|
|
|

b'h

i will be programmatically importing a text file into a table. i have saved the import steps. i will use this:

DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

to do the import.

this is what SpecificationName means:

Specification Name The specification name for the set of options that determines how a text file is imported, exported, or linked. For a fixed-width text file, you must either specify a specification name or use a schema.ini file, which should be stored in the same directory as the imported, linked, or exported text file.

i do need a specific specification; however i do not know how to specify one. when i manually imported a table, i did save the specifications for my import, however i do not know how to call this in the TransferText.

does anyone know how to specify SpecificationName ?

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about vba