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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP Utility

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-11 : 14:04:35
Ang writes "How to Import Fixed Length Text File into SQL Server 7 database By Using Bulk Copy Program ?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-11 : 14:28:15
See here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19706

A format file will allow you to import fixed-length files. Although, if you can use DTS it will be much easier to have DTS handle the import.

Go to Top of Page
   

- Advertisement -