Import textfile

  • Thread starter Thread starter Dominique Heyler
  • Start date Start date
D

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
 
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.
 
Back
Top