473,320 Members | 2,024 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Reading Excel file into datagrid asp.net

Hello Allo,
I am creating a page that allows a user to upload an excel file, and
display the contents in a datagrid. The problem I am having now is
that, some of the columns have both numeric and alphanumeric data.
How
can I upload the file into a datagrid as it is? Is it possible? I do
not want ASP.NET to automatically determine the data type. Is it
possible to just upload the numbers as strings as well? What are my
other options? Thanks in advance for your help.

The problem is similar to

http://www.mcse.ms/message519804.html

I have also posted this in excel programming section.
Regards

Feb 26 '07 #1
1 3728
"Omar" <ba*****@gmail.comwrote in message
news:11*********************@8g2000cwh.googlegroup s.com...
Is it possible?
Yes.
I do not want ASP.NET to automatically determine the data type.
Ah - well, that pretty much rules ADO.NET out...
What are my other options?
http://www.aspose.com/Products/Aspos...s/Default.aspx
Feb 26 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Paul | last post by:
I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...
2
by: Phoebe | last post by:
Hi, Good Day! I've a coding which Open Excel File and save it into a recordset. But the below coding "died" when reached the SQL statement. Can someone help? Thanks in advanced. rgds...
0
by: mkl | last post by:
Hello I use this code to read a Excel File. Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\test\bla.xls;Extended Properties='Excel .0;HDR=YES;'"...
3
by: Brad | last post by:
I'm having a problem reading data from an Excel file into a dataset. Can anybody give me an idea of what's happening? I've included the problematic source and the error message to the end of this...
5
by: SantaClaus | last post by:
Hi all, I'm reading an excel file in VB.net. It works fine if I don't give any condition in the 'where' claus. My code is Dim myDataset As New DataSet() Dim strConn As String =...
8
by: msghaleb | last post by:
Hi all, I've created an asp page which is reading an Excel file, the code is working ok only not on IIS !! here is the code: oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _ ...
2
slapshock
by: slapshock | last post by:
please help me with my problem... i want to read data from an excel file and then save it to the database... i used stream reader but it did not work... please give the code on how to do it...
1
by: sangeethakrishnan | last post by:
I want to read an excel file(on my local machine) in a web application(application resides on a remote machine) without uploading(saving) the file on the remote machine using ASP.net. Its urgent,...
1
by: mohan21_kumar | last post by:
Hi, I'm using oldbd driver to retirve the data from an excel file. When the particular column of an excel is blank and filled with one record at the last row of an excel, all the column value...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.