Excel and ASP?

[ReturnOfThePyro]

n00b question, I know...

databases are easy, but how can I pull info from a spreadsheet? (namely a csv file)

 

[palbano]

a cvs file is not a spreadsheet.

to work with any file (that is on the server) you can use the FileSystemObject. Look in the FAQ's for working with that ActiveX control.

-pete

 

[TonyU]

[tt]check with the guys are

http://www.4guysfromrolla.com

they always have nice hot to's...

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​

 

[ReturnOfThePyro]

all of the answers i've seen address access, MySQL and databases, but I need to know for spreadsheets! old ones at that, (hence the csv format)

 

[palbano]

csv format == comma delimited ?

if so use the FileSystemObject.

-pete

 

[ReturnOfThePyro]

I'm not too good at this... so how exactly would I import data from cell "A1" of "sheet1.csv" into a field on my page?

 

[palbano]

Pyro,

is csv a comman delimited file? I thought it was but maybe i'm incorrect.

If it is,(comman delimited) then you have to open the file and parse it to find the specific data you desire. Then you can put it wherever you want it on your page.

-pete

 

[palbano]

>> is csv a comman delimited file?

comma darn fingers (comma delimited file)

-pete

 

[ReturnOfThePyro]

I believe it is...

once again:

I'm not too good at this... so how exactly would I go around doing this?

 

[onpnt]

try using Tek-Tips advanced search for past 6 months. I know of at least three threads that Tarwn gave explicit directions and details in what you need to do. In fact your title alone should hit many threads onpnt
_________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com

 

[Tarwn]

CSV: Comma Seperated Values
This is not implictly an MS Excel filetype, just one more they have adopted over the years to provide as much compatibility with other applications.

I can't actually remember posting on reading a CSV file recently, but that doesn't mean much consdidering my memory

You can actually use the Jet provider to connect to an excel file just as you would an access database. I did a quick search and turned up this link, which should prove helpful:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0193.asp

-Tarwn ________________________________________________
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048