Search results for query: *

The question has been answered. When the data is imported the column was being set as numerical. When the mixed type data was seen it was discarded because it didn't fit the data type. If I was using excell I could have added IMEX=1 to the extended properties in the connection string. Example...

I am importing a .csv fiel into a datagrid. When I import the data, some of the columns are left blank. data from .csv file: output from datagrid: As you can see some of the data in the ItemNumber field has been imported and some of it hasn't. It seems that all of the 000p0*** fields...

I am new to vb and writing a program in vb.net 2005 in which I convert a fixed width file to csv then read it into a datagridview. When I convert the data it works fine. Sample: converts to: But when I read this data into the datagridview it looks like this. Sample: for some reason...