Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-09 : 08:49:09
|
| Aparna writes "Hi,We need to upload data from text file and Microsoft excel file to SQL Server tables. Text file contains about 5 lacs of records and excel contains about 1000 records.Which is the optimal way to perform this? I was told a few options like: bcp bulk copy DTSI am new to SQL server and I need help on this urgently. Kindly help me.Thanks & Regards,Aparna S." |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-11-09 : 17:43:55
|
| bcp is probably the best way, but if you're a beginner then I think DTS is the simplest as there is a wizard for it, the wizard should be able to cope fine with basic text and excel. You may have to run it twice if you do it this way, you could then copy everything from one package to the other so that it is all together, or you could create a new package that contains both that you have just createdsteveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
|
|
|
How to perform DTS programatically?