can ASP read an excel document

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

can ASP read an excel document

Logged in as: Guest

arrSession:exec spGetSession 2,3,525

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> can ASP read an excel document
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

can ASP read an excel document - 12/11/2001 10:36:27 AM

scaifs01

Posts: 10
Score: 0
Joined: 9/19/2001
From: United Kingdom
Status: offline

I know it sounds stupid, but can you read an excel document using ASP. I've seen a script that automatically spins a chart around in excel using VBS. So i guess you can. Just is it different to reading from a text file or database.

I have scripts that read text files and databases and list the contents.

If i want to read from an excel document is it similar code to reading from access, i.e. do you have to provide a connection string and stuff

anyhelp would be appreciated.

Post #: 1

Re: can ASP read an excel document - 12/12/2001 2:44:52 PM

Posts: 1
Score: 0
Joined: 12/12/2001
From: United Kingdom
Status: offline

Yes

Well I've up on an intranet to read and write to various excel sheets. I've used two methods that make use of the ADO standards. The first is to set up a link in the ODBC on the server (may be not much help to you in the world of internet) and referance this in the connection string. The other way is to construct the basic connection string stating the driver as microsoftexcel.xls (check the syntax!!) and then referance the path and file (you can get to access files in the same way)

Sorry I've not got any code

(in reply to scaifs01)