I have a table
which i need to copy some data into. The data format is
comma delimited with quotes around strings.
Using the table below. At first I created a format file
using the correct types ie SQLINT but found the integers
were ed and seemed to correct itself when I just used
SQLCHAR. Now if possible I would like to remove the quotes
that appear around strings after I have imported the data
CREATE TABLE [dbo].[ImportTest] (
[idkey] [int] NOT NULL ,
[testdesc1] [varchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[idCountry] [int] NOT ...