how do I set up and use the schema.ini import file in access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am constructng a database using some of the same import/Export
Sepcification tables from an existing database I have built in access 2003. I
firstly wanted to copy all the complete import specification tables from one
database to the new one but don't know where they live or if I can do that. I
read in the microsoft support section about a 'schema.ini' file that can be
used to contain all the import specs I require. Has anyone used this file
method? If so can you tell me how to construct it (what specifically should
it contain) and how I get access to refer to it?
 
Hi Porky,

You can import the import/export specifications from one database to
another. Just use File|Get External Data|Import, and once you're in the
import wizard click the Options button. This gets you a checkbox for
importing the specifications.

For schema.ini, see e.g.
http://office.microsoft.com/en-us/assistance/HP010321661033.aspx
Create a Schema.ini file based on an existing table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512
How to Use Schema.ini for Accessing Text Data
http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090

Documentation for Schema.ini is towards the end of the Help topic
"Initializing the Text Data Source Driver" (under Microsoft Jet SQL
Reference).
 
Back
Top