csv and ADO, autoassigning wrong variable types

[BodwadUK]

Hello,

We have a csv file from another source that we read in using the ADO object. A problem has occured where the ADO is reading in the first few records of song titles as numbers and then not allowing us to read in later records that are obviously going to be strings.

Does anyone know how we can force the ADO to take all fields in as string and not auto assign field types to numeric values only?

Thanks

[salvelinus]

What is an "ADO object"? ADO is a way of manipulating data. There are objects in ADO, such as a connection object, etc., but never heard of "ADO object".

[BodwadUK]

You know what I mean. Its an ado connection to a csv file

[si_the_geek]

Actually he doesn't - there are lots of alternate "ADO objects" you could be using (eg: a Data Control , a Connection, or a Command), and they are noticably different.

Anyhoo.. in this case it is not relevant, and the answer can be found in this article from Microsoft, in the section titled "I Dozed Off"!

[BodwadUK]

Cool cheers thats exactly what we need

Its an ADO Connection