470,596 Members | 1,608 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

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

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
Jun 27 '07 #1
3 4891
srinit
43
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
Jun 28 '07 #2
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.
Jun 28 '07 #3
Hi,

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

Cheers.
Jun 28 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by solex | last post: by
4 posts views Thread by eggie5 | last post: by
7 posts views Thread by =?Utf-8?B?TW9iaWxlTWFu?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.