retrieving values from .txt file to be placed in a sql statement.

[wsam]

I am trying to create a sql script that gets values from a text file that looks like:

2234
1233
4455
223435

the statement will have to loop through the whole list, putting the information into another .txt file

the statement is :

select * from <table t> where t.id = x.txt <value from text file>

can anyone help?

 

[tlbroadbent]

I'd recommend loading the data from the first text file to a table via DTS (step 1). Then export the result of joining the two tables to the other text file via DTS (step 2).

SQL doesn't directly manipulate text files. However, it handles tables and relationships very well. Terry

http://members.home.net/tlbroadbent/index.htm