Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default asp having problem accessing excel 2002

asp having problem accessing excel 2002

good day,

I have an ASP(Classic) application that is retrieving data in Excel 2002.
The problem is it can't access the data in it. But previous versions of
excel have no problem. Is this a bug? Does microsoft already have a solution
for this?

Here is my code

' Create a server connection object
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "DBQ=" & Server.MapPath(exceldb) & ";" & _
"DRIVER={Microsoft Excel Driver (*.xls)};"
dim strConn
strConn = "DBQ=" & Server.MapPath(exceldb) & ";" & "DRIVER={Microsoft Excel
Driver (*.xls)};"

Any idea why this one is not working on Excel 2002?

Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem accessing Pivot table Excel 2007 ann Excel Worksheet Functions 0 February 19th 09 05:42 AM
Problem seeing and accessing top of sheet egii Excel Discussion (Misc queries) 1 January 11th 07 02:52 AM
PasteSpecial problem in Excel 2002 [email protected] Excel Programming 2 June 13th 05 10:12 AM
Problem accessing Oracle Public Synonyms from Microsoft Excel 2002 Sandeep Excel Discussion (Misc queries) 1 January 5th 05 09:31 AM
Problem with Excel 2002 Doc Excel Programming 8 December 29th 03 03:52 AM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"