Importing mixed datatypes from Excel to Visual Studio

[bd528]

Hi all,

I am attempting to import data from Excel 2010 to a Visual Studio 2010 datagrid.

Whilst the sheet imports successfully, cells with mixed data (ie : "CD2341234S") doesn't seem to be imported.

Is there a way to get around this? I don't need to hold the data in a datagrid, but as I am new to Visual Studio, this seemed the most simple way...

Thanks in advance!

 

[bd528]

...To be more exact, if my column of Excel data contains :-

D7646
78762
G899R

then only D7646 and G899R are imported.

 

[jmcilhinney]

If we knew what you were doing it would make it easier to know what you're doing wrong. I'm guessing that you're suing ADO.NET but I'm not going to base and answer on a guess when that could be quite wrong.