ADO - Schema - Import Text Wizard

[Peter Nuenz]

I have created a routine that automates importing data
files into my database. It uses the DoCmd with
transfertext. This works fine but I would rather use
ADO. I have some code but I need a little extra. Using
the advance option on the above import wizard I have saved
a file specification. The most important thing is that
the delimiter is a pipe character. ADO requires a schema
ini file that duplicates the file spec. Can I export my
saved file spec file and use as an ado schema file? How
do I find out what the parameters / options are for the
schema ini file or at leasdt some examples?
Thanks, Peter

This is a second thread but in a different sub group hope
no one gets upset.

 

[John Nurick]

Hi Peter,

Schema.ini is documented very sketchily in Help and more fully at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp

Search MSDN for "schema.ini" for even more information.

I don't know how to export an import specification; doubtless the
specifications are stored somewhere in a system table, but it's probably
simpler to start from scratch.

I have created a routine that automates importing data
files into my database. It uses the DoCmd with
transfertext. This works fine but I would rather use
ADO. I have some code but I need a little extra. Using
the advance option on the above import wizard I have saved
a file specification. The most important thing is that
the delimiter is a pipe character. ADO requires a schema
ini file that duplicates the file spec. Can I export my
saved file spec file and use as an ado schema file? How
do I find out what the parameters / options are for the
schema ini file or at leasdt some examples?
Thanks, Peter

This is a second thread but in a different sub group hope
no one gets upset.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.