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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Optimise import text file

Author  Topic 

frlep
Starting Member

4 Posts

Posted - 2008-03-11 : 10:08:35
Hi,

Please can you help me,

I have created an database with 3 fields

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-11 : 10:09:48
What method are you using for import?
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-11 : 10:17:22
more here...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98801

Em
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-11 : 10:24:51
Try using BULK INSERT method.
http://msdn2.microsoft.com/en-us/library/ms175915.aspx
Go to Top of Page
   

- Advertisement -