Greetings,

I am trying to import an excel spreadsheet into my database. The
spreadsheet contains the list of dealers for the site and this is
updated on a regular basis.

What I had originally done was set up an stored procedure where I would
have already imported the spreadsheet into a table, and then run the
stored procedure to import into the dealer's table for the system.

Is there a way where I can do the following:

1. Add the spreadsheet to a location on my server.
2. Get a DTS module to run on a particular schedule and import the
spreadsheet from the location in step 1 without too much user interaction.

If this is possible to do what are the steps to do this or is there a
better way to get this information into a database, or is the stored
procedure approach that I have done the best way to go about this.

Thanks.

JD