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