Re: Error using ado to read cvs file
- From: "ekkehard.horner" <ekkehard.horner@xxxxxxxx>
- Date: Mon, 17 Sep 2007 10:55:19 +0200
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.
.
- Follow-Ups:
- Re: Error using ado to read cvs file
- From: Light
- Re: Error using ado to read cvs file
- References:
- Error using ado to read cvs file
- From: Light
- RE: Error using ado to read cvs file
- From: "Walter Wang [MSFT]"
- Re: Error using ado to read cvs file
- From: Light
- Error using ado to read cvs file
- Prev by Date: Re: Error using ado to read cvs file
- Next by Date: Re: Class not Registered (VB 6 - Dao 3.6 - DBGrid and Data Source)
- Previous by thread: Re: Error using ado to read cvs file
- Next by thread: Re: Error using ado to read cvs file
- Index(es):