SQL text file question

[fernandopi]

SQL 7 database. Table contains the filename of xtg files, but I can't get the text from the files into my query. How do you get information from a text file if you have the location, and the name of the file?

Example: the text files exist on T:\
The table contains the filename 209875.xtg
How do I get the contents of the text file to show up?

 

[SQLDenis]

use DTS or BCP, look it up in Books On Line

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

Or Bulk Insert.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com