Schema.ini

[.ooooooOoooooo.]

Hi,
I've just discovered the schema.ini file. I'm wondering if it can help out
with a problem we have.

We have an application that we have on a remote system shifts out data as
CSV files but does not provide any column headers.

Can column headers for a headless file be provided in the schema.ini file ?

TIA

..ooooooOoooooo.

 

[John Nurick]

Yes, but...

If the file format is constant and you're importing the data, you can
create the table in Access with the field names you need and then import
the headerless csv file.

If the file format isn't constant, you need to create a schema.ini entry
for every different filename and format, which can be tedious.