wildcards in schema.ini

[Guest]

Is it possible to use wildcards in schema.ini files when the schema is the
same but the file name is different.

Instead of this

[data_1.csv]
NumberDigits=5

[data_2.csv]
NumberDigits=5

[data_3.csv]
NumberDigits=5

I want to do something like this

[data_%.csv]
NumberDigits=5

This is just a simple example to get my question across, the actual
schema.ini file that I need to create is going to be enormous if I have to
create every one long handed

Thanks in advance
Steve

 

[John Nurick]

Hi Steve,

I've never heard of schema.ini accepting wildcards. But all you have to
do is to have your code either rename your data file to match an
existing entry in schema.ini before importing it, or else create a new
schema.ini each time.

Or - if you're using DoCmd.TransferText - you could forget about
schema.ini and use an import specification in the database.

Is it possible to use wildcards in schema.ini files when the schema is the
same but the file name is different.

Instead of this

[data_1.csv]
NumberDigits=5

[data_2.csv]
NumberDigits=5

[data_3.csv]
NumberDigits=5

I want to do something like this

[data_%.csv]
NumberDigits=5

This is just a simple example to get my question across, the actual
schema.ini file that I need to create is going to be enormous if I have to
create every one long handed

Thanks in advance
Steve

 

[Guest]

Hi John

I am actually exporting not importing, but your suggestion of taking 2 steps
still works.

1. export to a generic file (as defined in schema.ini)
2. rename the file ( Name "D:\test\data.csv" As "D:\test\data" & version &
".csv ")

Thanks again
Steve

Hi Steve,

I've never heard of schema.ini accepting wildcards. But all you have to
do is to have your code either rename your data file to match an
existing entry in schema.ini before importing it, or else create a new
schema.ini each time.

Or - if you're using DoCmd.TransferText - you could forget about
schema.ini and use an import specification in the database.

Is it possible to use wildcards in schema.ini files when the schema is the
same but the file name is different.

Instead of this

[data_1.csv]
NumberDigits=5

[data_2.csv]
NumberDigits=5

[data_3.csv]
NumberDigits=5

I want to do something like this

[data_%.csv]
NumberDigits=5

This is just a simple example to get my question across, the actual
schema.ini file that I need to create is going to be enormous if I have to
create every one long handed

Thanks in advance
Steve