Importing an Excel SS into SQL

[u4eas]

I have a dynamic website that needs to be populated with a LOT of data. I am using SQL for the DB and access for the entry into SQL via odbc.

I wanted to create a excel file that contained all the data needed for a specific table and then import the SS into SQL. Instead on connecting to the DB and doing the entry live into the DB.

Is there an easy way to do this? Or is there an app available that can pump this data in?

Thanks in advance!

u4ea

[TheNige]

The easiest way is to use SQL DTS (Data Transformation Services). Open SQL Enterprise Manager and look for DTS under your server. You can also just right click on your table and and select "Import Data" which you can then turn into a DTS package that you can even schedule to run whenever you want.

DTS is a big beast and can do a lot of powerful things, but it can do simple things easy too.