FixYa.com
Technical Support, Instructions & Repair Service


Tags:

Microsoft Excel 2000 Step by Step  for PC

Excel Loading Problem (by 2 users)

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.........

This Problem has been added to the Share Your Expertise Page under "My Work Queue".

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
Not Rated (0)

Ultumix


Rank:Master Master
Rating: 80%, 13 votes
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:

Can you Help with these Education and Reference Software problems?

Education and Reference Software
math
title-area of trapezium .... Answer This...
Repair Service
Find Education and Ref. Repairman Near You:

FixYa does not evaluate or guarantee the accuracy of any information provided through its proposed solutions, posts, or Expert Assistance Sessions. By entering this site you declare you read and agreed to its Terms. You may NOT copy or distribute the content that appears on this site without written permission from FixYa Inc.
© 2005-2008, FixYa, Inc. or its affiliates
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!