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




MS Sql Server LazyDBA home page