ASP database importing

Jon · Web Design Admin Joined: Jul 12, 2004 Posts: 72

I have taken over a website where there is a list of stores.
I was told someone used to import an excel file onto the server and that it would update.

What would you need to tell me what it is that I must do for the importing of the .xls file ?
_________________
Free Music Cpop Server Definition

ci5co · Web Design Newbie Joined: Aug 18, 2004 Posts: 89

I'm assuming that you are using a SQL database running on SQL server.

What you need to do is import the data in the excel document into a table. Strangely enough I had to do this exact thing today

There is a good article detailing a few ways to accomplish this here http://www.databasejournal.com/features/mssql/article.php/3331881

Here is a code snippet if you don't want to read the article. It will read an excel file (c:\excel1.xls) into a SQL table. You can then obviously use an insert to put the output from this query into one of your tables.