Hi All,
   I have a problem in reading the excel data.
In the excel sheet I have column named "EmpCode"
and it has values like 234,177,478,202,9033,9023,
733,4890,RC392,RC922,RC738, etc.
When I read the excel data using ASP.NET, I was able to
read only the interger values.
The string values like RC392, RC922,....
are unable to read.
In the excel the "EmpCode" has "general" type.
I have also tried with "Text" type and "value" type
but could not achieve the result.
Can any one help me to sort this problem

Can you let us know how you are trying to access the data from the Excel sheet, may be then we will be able to help you out!!!

Regards
Mike

Hi,
   I have tried with two approaches.
One is by using "Import and Export data" wizard of sql server.
Second is by using OleDbSchemaTable in my ASP.NET application.
Both the approach does not give the desired result.
What I suspect is that, based on the data from the first 6 to 7 rows
in the excel sheet the datatype for the column in excel is decided.
Consider for example I have got 10 rows in a sheet.
First 8 rows has numeric value and last 2 rows has alphanumeric value. When I export the sheet using "Import and Export data wizard"
or read the data using OleDbSchemaTable in my ASP.NET application,
I could get the exact values for the first 8 rows and for the remaining 2 rows I could not get the values.

Doesn't know exactly how the wizard works, but I know that access import wizard do exactly that, take the firsts 5 rows to get the data type of the column... so maybe is the same???
You can do 2 things: insert a dummy row at the top of the table, or just mixed the rows so the wizard will take every column as varchar...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi,
  Thanks for your ideas. I will try with your ideas and sort out the problem.

for reading in excel, also check out this link:

http://dailydoseofexcel.com/archives...ed-data-types/

There are a few hangups everyone experiences and it sounds like you're already on the right track. The jet driver defaults to reading in the first 8 rows of data, and determines a data type based on that. What you want to usually do is override that and force it to use the mixed data type for columns with varchar-like data.

If you don't need a program to do this, you should definitely just use SQL Server. SQL Server 2005 makes it pretty easy. 2000's DTS is not as easy but you'll figure it out....