Import Excel data into SQL Database

[elcephus]

Hello ALl,

IM just a beginer at this SQL Database stuff and was wondering if somone could point me to some web resources where I could read upon how to import excel\access\etc... database into a sql 2005 database? Thanks.

 

[dwight1]

Elcephus,

You can run a Data Transformation Service (DTS). Click on Start => Programs => Microsoft Sql Server => import and export data.

Then select your data source from and to that's it, you should be able to transfer the data as per your requirements daily or onetime etc.

There are other ways too but this is the simplest.

Dwigth

 

[elcephus]

Thanks, didn't know SQL could be so easy.