Where is the Access Schema.ini file located once it is created wi.

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

Guest

I used the import wizard and created a schema.ini for importing fixed field
length files. I need to know where that INI was stored. I would like to
place it in the same directory as the files. Does anyone know where that
file is located or if I can use this file as an ini?
 
The import wizard doesn't create a schema.ini file, but an import
specification that you can re-use by passing its name to
DoCmd.TransferText.

This article shows to create a Schema.ini file based on an existing
table:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512

If you want to go exploring, the import and export specifications are
stored (in an undocumented manner) in the hidden system tables
MSysIMEXSpecs and MSysIMEXColumns.
 
Back
Top