Transfer data from Excel to Access using ASP

How to do it?

[iloveu]

I am going to write a ASP code (not .net) to import my excel file to Access database. Seems it is difficult to get useful information by Google. Can anyone tell where I should find relevent information?
Thanks.

[KeywordROI]

I seem to remember that there is a data source that you can use with Excel in ASP (similar to the jet something for Acess). I think you have to give a certain area in Excel a name and then you can access it.

Good Luck

[Prolific]

You can use MS Access itself to import the data. Use the import data wizard and point it at the excel file and it will let you map fields. Super easy :)

[northbath]

I am looking for a similar answer. I am working on a project for a friend that is stuck. I am teaching myself asp and it's running slow. All the data is in access, and he wants to display his spreadsheet on his site. Also, when data is sent to the database, he has to manually refresh his spreadsheet in order to display the new data that was just inputted. Is there a way to send data to a database and then transfer to excel and then come back to the site with one button (function) without manually refreshing?

[mattur]

iloveu: I've done a similar thing, using an Excel file to batch upload products into a database using ASP. You can query an Excel spreadsheet or range via ADO the same way you can query an Access database. You need to use a slightly different OLE DB connection string and SQL syntax, eg:

strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\your-excel-file.xls;Extended Properties=Excel 8.0;"

strSql = "SELECT * FROM [your-excel-sheet$];"

See Manipulate Excel Spreadsheet Data in ASP Using ADO [msdn.microsoft.com]

Northbath: it's possible to return data from an asp page to open in Excel, see How To Display ASP Results Using Excel in IE with MIME Types [support.microsoft.com]