The only thing that you could possibly do from within T-SQL is use the BULK INSERT command.

Jay



From: Sheldon Jeff
Sent: Mon 26-Feb-07 16:18
To: LazyDBA Discussion
Subject: Import data from a tab delimited using SQL?


Re-writing a journal rename/format process to get it out of Access and
into SQL.



What is the best way to take a regular.txt file and import it into a SQL
table (the mappings are identical so no CONVERT statement needed)



I want to include this action within a stored procedure and not like DTS
or SSIS. I need it as a stored procedure so I can give it to the users
via our ERP system remote stored procedure call system.





Thanks



Jeff





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page