Go Back   Velocity Reviews > Newsgroups > DotNet
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

DotNet - Reading Excel sheet from asp.net returns empty cell

 
Thread Tools Search this Thread
Old 09-05-2009, 05:06 AM   #1
Red face Reading Excel sheet from asp.net returns empty cell


Hi,,

I am uploading the Excel sheet to Dataset ...

for this i have used the oledb conn string ..

I am using the following connection string to read values from rows from an
excel sheet into a dataset/datatable. One of the columns contains
alpha-numeric values ie. 400c
When accessing the value of this cell it returns "" (empty string).

Dim strconn As String = "Provider=Microsoft.Jet.OleDB.4.0;Data
Source=ExcelFile; Extended Properties=""Excel
8.0;HDR=YES;IMEX=1;ImportMixedTypes=Text """

It shosw the error Could not Find the Installation ISAM File


venkatu2005
venkatu2005 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46