Re: Error using ado to read cvs file



Light schrieb:
One problem though, the file name in the scheme.ini file has to be exactly the name of the file and I found out I can't use wild card like:

[*.csv]
ColNameHeader = True
MaxScanRows = 10000
Format = CSVDelimited
CharacterSet = ANSI

Is there a way out of this?

TIA.
[...]
You can use

[<uniquename>.csv]
ColNameHaeder = True
...

and rename each current file to <uniquename>.csv; of course, after
processing, you should rename it back.
.