import text file to SQL

• antontj

  Old Hand

  Points: 368

  More actions

  August 20, 2003 at 1:18 am

  #81660

  hi,

  I want to import data form text file to SQL. The data contain character which is supposed to be numeric in SQL table. Error conversion appears when the data contain minus (-) sign in the behind.

  (ex. 9999.99-)

  can someone help me ?

  thanks,

• 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