Re: Error using ado to read cvs file

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.


""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
    ... 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: 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: Delete record
    ... What data type is Codigo? ... then are you sure that first column actually contains a value? ... > Dim MySet As DAO.Recordset, ... > the register to be deleted are copied on the first register of the table. ...
    (microsoft.public.access.forms)
  • Re: Trouble opening a form from a subform combo box
    ... combobox's Row Source query, as you don't see the first column because ... its Column Widths property sets the first column to 0" wide, ... tblPartnumber table, which is an AutoNumber. ... > Part_Number (data type text) ...
    (microsoft.public.access.forms)
  • Re: Single precision in Simulink?
    ... "Complex signals of any data type and non-double real signals must be ... in structure format. ... The first column must contain time values and the ...
    (comp.soft-sys.matlab)