Copying large amount of data form MS Excel to MS Sql Server

[AnishAbs]

Hi ,
I have got a senario in which large amount of data should be copied from MS excel to MS SQL server. which is the best option to do so. Because when I use recordsets the process is very slow and it effects the performance. Any one please suggest me.


Thanks
Anish

[srinit]

Hi ,
I have got a senario in which large amount of data should be copied from MS excel to MS SQL server. which is the best option to do so. Because when I use recordsets the process is very slow and it effects the performance. Any one please suggest me.


Thanks
Anish

HI Anish,
I am working on sql2005.in this right click on thedatabase
--->go to all tasks .
------------>select import data.
-------->select msexcel
---------->enter the exel file path
----------->select all data in exel
---------->click on finish.


i think it is also works in sql2000. in 2000 you have to do it enterprise manager

[bharadwaj]

hi,
if the no of records are greater than 67000 in excel,it is not possible to copy to sql server.you need to split that excel into different files.
if you can copy that excel to MSaccess you can send large data to sql server
through dts only.

[patelaashish]

Hi,

Use the Import/Export wizard to import the excel file into you destination database.

Cheers.