Re: Error using ado to read cvs file

Hi Walter and EH,

Thanks for your replies, now it all works!

Thanks and Cheers.


""Walter Wang [MSFT]"" <wawang@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:7hI5QHe9HHA.5532@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Light,

You can create a file named 'Schema.ini' in the directory to specify each
column's data type. By default the driver uses first row's data type to
determine, in your case, the first column in first row is a number,
therefore it treats the column as a numeric one.


#ConnectionStrings.com - How to connect to Textfile
http://www.connectionstrings.com/?carrier=textfile


Regards,
Walter Wang (wawang@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: Error using ado to read cvs file
    ... the name of the file and I found out I can't use wild card like: ... By default the driver uses first row's data type to ... determine, in your case, the first column in first row is a number, ...
    (microsoft.public.data.ado)
  • RE: Error using ado to read cvs file
    ... You can create a file named 'Schema.ini' in the directory to specify each ... By default the driver uses first row's data type to ... determine, in your case, the first column in first row is a number, ...
    (microsoft.public.data.ado)
  • Re: Page Orientation capability in Unidrv? Reverse Print direction
    ... printer using a driver based on the Unidrv, and the printer doesn’t have the ... within your driver (no print processor magic required). ... I re-enabled spooling and got the EMF data type back. ...
    (microsoft.public.development.device.drivers)
  • Re: Page Orientation capability in Unidrv? Reverse Print direction
    ... all the pieces to the printer driver puzzle. ... I was able to successfully implement the print processor suggestion ... I re-enabled spooling and got the EMF data type back. ...
    (microsoft.public.development.device.drivers)
  • Re: Why in stdint.h have both least and fast integer types?
    ... There is no point making a data type "fast" if it is to be ... exactly 16 bits and another that behaves as if it has at least 16 bits. ... wouldn't prefer to specify that array as int16_t. ... architecture of the underlying machine (in this case, primary cache size) ...
    (comp.lang.c)