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)
 Text file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-03 : 07:45:46
amarprit writes "i have text file with following contents

1234;11;12;13;14
1235;12;12;12

i want each of the above to be transfered to SQL table

e.g. id 1234
id_1 11
id_2 12
id_3 13
id_4 14

I know DTS works but can you please let me know how should I perform this task everyday without using DTS at all..


Thanks"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-03 : 07:59:40
You need to split them and insert into table
See here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -