Update: I exchanged "EmployeeID=@PMID" for "EmployeeID = @PMID". The error message has gone but I still get the blank paging with no sign of my footnote "This information is..."

Robin

Thanks for your input Steve, I tried the following:

SET LANGUAGE British

GO

DECLARE @msgstr VARCHAR(80)

DECLARE @cmd VARCHAR(80)

DECLARE @PMID INT

DECLARE @forename VARCHAR(30)

CREATE TABLE ##texttab (c1 text)

SET @msgstr = 'THE FOLLOWING QUOTES ARE CURRENTLY...

SET QUOTED_IDENTIFIER solved my problem.

thanks

Robin P

SET LANGUAGE works just fine, thanks - though I notice that ADO throws out an error message, code 0 which I can test for and avoid.

Robin P

There are null values all over the place, before and after where Import decides it has a problem. Just for grins I redid all four dates in record 2867, but...

David.....I have been having problems posting, so I will try again, picking up the thread where left off:

David,

Thanks for your response, I managed to lose my reply this morning (hit...

Thanks for your reply. I'm afraid I don't know the procedure for either using the Access Documentor or scripting my table.

There is definitely something wrong with a data cell...