Export Data From Excel to ASP and SQL Server

•

What is DaniWeb IT Discussion Community?

You're currently browsing the C++ section within the Software Development category of DaniWeb, a massive community of 402,624 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,140 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our C++ advertiser: Programming Forums

Thread Tools Display Modes

Views: 7058 | Replies: 3

•

Join Date: Sep 2005

Posts: 2

Reputation: Chandrakumar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Chandrakumar Chandrakumar is offline

Offline

Newbie Poster

Export Data From Excel to ASP and SQL Server

Sep 22nd, 2005

I copied book1.xls into IISServer c:/inetpup/wwwroot

objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/book1.xls") &";ReadOnly= true ; UID=admin;"

Dim strSQL
excelfilename = "Book1.xls"

strSQL = "select * from " & excelfilename

Dim objRS
Set objRS = Server.CreateObject ("ADODB.RecordSet")
objRS.Open strSQL, objConn,3,3

When I execute the page

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.

Please help me

Regards
Chandrakumar
chandrakumar@dzinegarage.com

•

Join Date: Sep 2004

Posts: 6,069

Reputation: Narue has much to be proud of

Rep Power: 26

Solved Threads: 419

Narue

Offline

Expert Meanie

Re: Export Data From Excel to ASP and SQL Server

Sep 22nd, 2005

That's Visual Basic, not C or C++. Please direct your question to a more appropriate forum.

I'm a programmer. My attitude starts with arrogance, holds steady at condescension, and ends with hostility. Get used to it.

•

Join Date: Sep 2005

Posts: 2

Reputation: Chandrakumar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Chandrakumar Chandrakumar is offline

Offline

Newbie Poster

Export Data From Excel to ASP and SQL Server

Sep 22nd, 2005

I Upload Book1.xls in to IISServer machine c:\Inetpub\wwwroot

When I am Using this code in ASP

Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
'response.write Server.mappath("/")
'response.end
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/book1.xls") &";ReadOnly= true ; UID=admin;"

Dim strSQL
excelfilename = "Book1.xls"

strSQL = "select * from " & excelfilename

Dim objRS
Set objRS = Server.CreateObject ("ADODB.RecordSet")
objRS.Open strSQL, objConn,2,3

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file 'Book1'. It is already opened exclusively by another user, or you need permission to view its data.

Please help me.