Hi,



I have the following problem:



When I try to bulk insert a text file into SQL 7 database,

the table is populated with values containing " character. Eg. "1827389"

How do I get rid of it?



Here's the statemet I'm using:



CREATE PROCEDURE Bulk_Insert AS



BULK INSERT BTdata.dbo.[InvoiceHistory]



    FROM 'c:\InetPub\wwwroot\BtNew\invoicehistory.txt'



    WITH



        (



           FIELDTERMINATOR = '\t',



           ROWTERMINATOR = '\n'



        )



  Thanks for your help.



Petr