import excel file to sqltable in sqlserver 2000

• kiranmca24

  Old Hand

  Points: 389

  More actions

  May 4, 2009 at 4:12 am

  #200079

  so please give me the solution to import excel file into sqltable.

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  May 4, 2009 at 4:28 am

  #988017

  kiranmca24 (5/4/2009)

  ---

  so please give me the solution to import excel file into sqltable.

  you can import data from excel file to sql table in many ways, like use OPENROWSET, for more info see SQL BOL

  FYI:

  http://www.mssqltips.com/tip.asp?tip=1207

  http://www.mssqltips.com/tip.asp?tip=1393

  http://www.mssqltips.com/tip.asp?tip=1202

  http://www.mssqltips.com/tip.asp?tip=1515

• tosscrosby

  SSCoach

  Points: 18045

  More actions

  May 4, 2009 at 1:27 pm

  #988329

  You can use the DTS Import/Export Wizard. See BOL. Really simple to use.

  -- You can't be late until you show up.