Schema.ini

[Rod]

I want to use DoCmd.TransferText to import a CSV file.
I already have it working with Import Specification but unfortunately the
structure of the CSV often changes so I want to use a schema file to make
editing easier.

Q1 Is there any way of exporting my existing specification to a schema file?

Q2 Where can a find a complete list of the permissible contents for the
file? e.g. ColNameHeader=True Format = CSVDelimited etc etc

Q3 I have several CSV files in the same folder, each will need its own
schema. Do I just have both schemas in the same file?

Many thanks in advance.

Rod

 

[krazymike]

I haven't had time to try it, but it looks like you can make your own
schema programmatically.
http://msdn.microsoft.com/en-us/library/ms709353.aspx

 

[Ken Snell \(MVP\)]

With regard to #3, one schema.ini file is used to contain the info for all
the files in that folder. You make a "block" of info for each file, as noted
in the article whose link krazymike posted.