Re: Error using ado to read cvs file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.


.

Relevant Pages

  • Re: can NT4 servers and 2003 server play nicely together?
    ... NT servers and win2k3 servers can both be on the wire at the same time. ... rename the domain name. ... 4.Upgrade the new PDC to Windows Server 2003. ... 325857 How To Expand the Boot Partition During a Windows Server 2003 Upgrade ...
    (microsoft.public.windows.server.migration)
  • Re: How to replace single domain controller in domain with a singl
    ... Although you can use System Properties to rename a domain controller, Active Directory and DNS replication latency might temporarily prevent clients from locating or authenticating to the renamed domain controller. ... export of DHCP database for 2008 choose ... demote the old DC to member server, reboot and rename it, reboot ...
    (microsoft.public.windows.server.active_directory)
  • correction for Gary
    ... Renaming a Domain Controller issues. ... If you wish to rename a DC, ... To rename a domain controller, use the Netdom tool command-line utility, the ... domain functional level must be set to Windows Server 2003 as well. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Disk full error in Word
    ... Changing the server is unlikely to have any effect. ... it opens and locks up to 25 other files ... It does a write, rename, rename, rename, delete. ... It doesn't let go of some of the temporary files until the last application ...
    (microsoft.public.mac.office.word)
  • RE: from 2000 to 2003 but not upgrade
    ... Before you take any action to the new server, rename the 2k domain first, ... use the migration process to migrate user accounts etc. ... Meanwhile, you mentioned that you want to keep the original user profiles, ...
    (microsoft.public.windows.server.migration)