Home Forums SQL Server 7,2000 T-SQL import text file to SQL RE: import text file to SQL
fromnaija
SSCrazy
Points: 2876
More actions
August 20, 2003 at 6:51 am
#470583
You could BCP into a staging table as varchar, do some substringing to remove the (-) sign and import into the final table.
If DTS is an option, you could use ActiveX scripting to remove the (-) sign before loading into your table.
Joseph