Schema.ini

[Guest]

I am working with Access 03.

I am creating a macro to import data using the transfer command. My macro is
asking for a Specification Name. When I look at the help file it says that I
need to create a schema.ini file within the folder. (schema: A description of
a database that defines the attributes of the database, such as tables,
fields (columns), and properties.) The file I will be transfering is an excel
file.

But I can find no instructions on how to create the file or specify the
argument.
Can anybody help?

Thx in advance.

 

[Guest]

Hi Steve,

You should only need a schema.ini file if you are trying to import a fixed
length text file.

http://support.microsoft.com/search...&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Nurick]

If you're using the TransferSpreadsheet macro to import data from an Excel
workbook there's no option for a Specification Name, so I guess you're using
TransferText to import a CSV text file (which may show up on your computer
as belonging to Excel).

CSV files normally import just fine without using an import specification or
a schema.ini. You only have to use one or the other (not both) if you're
importing a text file that doesn't match Access's idea of CSV (e.g. a
tab-delimited file, or a fixed-width text file).