I have a CSV file with a column containing both Numeric and Text data. Using ASP code when I import the data from that column I only get Numeric data not Text.

Below is the example of data

CODE:
499
549
234

A23
T33
YY2

I tried to convert CSV column to text but it did not work.

Please advice.


Thank you,

And how is the CSV file formated?

Hmm, CSV is just formatted with commas? I know there is a few differences, but really the scheme is same way. I have created this for PHP to support all the ways of formatting CSV, but in reality it is very, very few differences.

Remember for data they have to be enclosed ("DATA").

post the csv file and code snippet that's parsing it... can't help much without those.

This is my code, hope to help you

PHP Code:

public DataSet GetDataSet(string filename )
     {
        string connString =string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Text;",Path.GetDirectoryName( filename ) );

        string cmdString =string.Format( "SELECT * FROM {0}", Path.GetFileName( filename ) );
       
          OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmdString, connString);

            DataSet dataSet = new DataSet();

            dataAdapter.Fill(dataSet);

            return dataSet;
    } 


not sure but csv file format is itself a text .. its a comma seperated text file. And still if its different version of csv type you just have to convert it there are lots of tool to convert it you dont have to write the program everytime

CSV is just formatted with commas? I know there is a few differences, but really the scheme is same way.






School Community | School Ranking