Import textfile

[Dominique Heyler]

Hi,

What is the syntax for importing a text file as a table, specifying the
fields data types and other parameters that you can set manually with the
import wizard.

Best regards, Dominique

 

[John Nurick]

Hi Dominique,

There are two ways to go:
1: Import the file manually; While doing so, click the Advanced...
button in the wizard to create and save an import specification. You can
then pass this specification as an argument to DoCmd.TransferText when
importing files of the same type.

2: Create a schema.ini file (in the same folder as the file to be
imported) containing the specifications. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp

or search MSDN for "schema.ini" for even more information.