posted by archmang on Dec 07, 2007
Hi All,
I have a problem in loading excel sheet from Windows Application i.e(VB.NET 2005) one of the column in excel sheet has mixed data type so while i am loading that column into my Grid it loads numeric values and some times it loads only text values .I have also set the IMEX =1 in the connection string property.It Doesn't work even then.So can any one send me the solution of retrieving mixed datatype column values from the excel.........
1 Other User Has The Same Problem
Comment by abuji, posted on Dec 07, 2007
Loading Excel Sheet in VB.NET Grid not showing Alphanumeric Vlues.
Solution #1
posted on Dec 10, 2007
try using OpenOffice.org instead of Microsoft Office. It should work and it's free.
Was this solution helpful? Show your Appreciation by rating it:
Suggest a new solution for this problem
Post a New problem for Microsoft Excel 2000 Step by Step
Email this problem
Post a New problem for Microsoft Excel 2000 Step by Step
Email this problem
Can you Help with these Education and Reference Software problems?
Repair Service
Find Education and Ref. Repairman Near You:
