Re: Error using ado to read cvs file
- From: "Light" <a@xxxxx>
- Date: Fri, 21 Sep 2007 13:12:08 -0400
Thanks ek.
Our web application allows users to upload csv file to the server before the
data in the fles are imported to the server.
Obviously, the file names will be different, thus the requirement for the
wild card .
"ekkehard.horner" <ekkehard.horner@xxxxxxxx> wrote in message
news:46ee40f8$0$7685$9b4e6d93@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Bob Barrows [MVP]
- 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
- Re: Error using ado to read cvs file
- From: ekkehard.horner
- Error using ado to read cvs file
- Prev by Date: Re: Compact and Repair
- Next by Date: Re: Error using ado to read cvs file
- Previous by thread: Re: Error using ado to read cvs file
- Next by thread: Re: Error using ado to read cvs file
- Index(es):
Relevant Pages
|
|