Craig
have you tried doing a find and replace in excel? You could replace the blanks within the "Sample Comment" column with the NULL operator asked for by Recorder.
Just an idea. It's not something I've done myself.
David

When trying to import an Access 2003 database containing 51,705 records using the ADO Connection option in the Import Wizard in v6.13.3.182 (SQL Server Express, Dict Seq 0000000F) it would only import the first 5 records and the date of 03/10/2004 imported as 10/03/2004. The date in the other 4 records was 01/01/2004. This database was originally created in Access 2007 but when it wouldn’t import the customer converted it to Access 2003. The Data Type for the date field was Date/Time and the Format was ‘dd/mm/yyyy,@’. Having had problems with dates in other imports I deleted the Format and tried again but the result was the same. I then changed the Data Type to Text and tried again. This time 13,047 records were on display in the column selection page of the Wizard and the date that had been displayed as 10/03/2004 was displayed as 03/10/2004. Further investigation revealed that the problem is actually a single “ (double quote) in the comment field in row 13,048. When that is removed all 51,705 records loaded into the column selection page although I haven’t time at the moment to complete the import to check that there are no other problems.

Is “ a SQL Server reserved character that shouldn’t be used? Or does it need to be handled in a particular way? What other characters cause this type of problem?

Have other users successfully imported data from databases created using Access 2007? When I have imported data into an Access 2003 database the Format of each field has been left blank but in this database the Format for the date field was ‘dd/mm/yyyy,@’, for the Comment field it was ‘dd/mm/yyyy’ and for the other text fields it was ‘@’. What are the repercussions of this? The Comment field was right justified when its Format was ‘dd/mm/yyyy’. When the Format was removed it changed to being left justified.

Simon,

I was importing from a text file

Craig