I have succeeded in exporting an access-table to an text-file, and the doing an dts-package in
sql-server - doing bulk insert to an sql-server-table.

All works fine, but in the text-file i am exporting the text-fields got " - around them which doesn't the numeric values gets.
example: "01111110";56;26;"MARS";8

When i am doing insert in sql-server the values became "01111110" in the table, and i want
01111110 whithout " " to do right sql-quiries.

Anyone knowing an extra command to the transfertext-command which get rid of the " " ?

Thanks.