ADO & Import Text Wizard's Advanced Options

P

Peter Nunez

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO - Schema - Import Text Wizard 1
Access2007: Import Error; worked in 2003 0
Import text file with macro - Invalid argument (Error3001) 0
Import text file data conversion problem in Access07 2
Access 2000 database Import Spec not working properly 1
Import using schema.ini file 6
old import specs failing in Access 2007 1
Import .xml with a macro 4

Top