how to import excel file to sql server 2005

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

dutchdba SSC Veteran Points: 281 More actions · Answer 1

The easiest would be to use the Import and Export Wizard. How to use this is described in the following article: http://msdn.microsoft.com/en-us/library/ms140052.aspx

/*----------------------------------------------------------------------------------*/
Always eager to learn.

swaroop.sahoo SSChasing Mays Points: 617 More actions · Answer 2

Hi,

You can use the below link.. The first link I got after googling. 😉

I normally change the datatypes in excel itself before importing. So that I can get the right type in mapping.