Does anybody know if it is possible to have a user upload an Excel spreadsheet to a website and then have that spreadsheet add it's rows to a table in an Access DB or SQL Server 2000 DB using .ASP and Jscript?

Any help would be appreciated.

Thanks,
Bob Kruse

I havent tried this yet but on the surface, i think this may work...

Simply use asp upload or something to get the file on to your server, the name of which is obtainable via the filesystem object. Now if you have connection string for an excell spreadsheet you can dynamically use the file name obtained above as the data source. Now you should be able to do with the spreadsheet what you want.....

ill try this today if i can..

Cheers

Leed

:: Son, im Thirty.... ::

This might work if your excel spreadsheet has a named region and is the same all the time?

That depends on how advanced you want to go, you could upload anything and then resolve it logically

its all in the code

:: Son, im Thirty.... ::