Does anyone know how to import an excel file into a database using ASP
If you are using ACCESS 2000 goto file --> Get External Data and then just follow the wizards instructions
I am trying to automate all of this in a web browser using ASP<BR>People will upload the file to the server and I want to use asp to create a database table based on the excel file that was uploaded
Excel Invokes on the Server just like .MDB. connect to the Excel File then allow access to modify it and add to it. Use Forms. then post the data back to the Excel File.