Hi Steve,

Many thanks for your reply. The requirements have changed now so that it is only csv's but I think your idea will work nicely for either requirement.

Regards,

Chris

Thanks for your reply Deni.

This would work if the number of Access Database I needed to produce was fixed. However, I need to produce a separate Access Database for each...

Thanks Noel, that has cleared up the problem for me.

Michael, we have two rows (default values) that are in every table, we decided to give these an ID of -1...

Thanks Michael,

I have nutted it out this far, try this example.

DROP TABLE tabA

CREATE TABLE tabA (

colA smallint NOT NULL,

colB INT IDENTITY(1,1)

)

EXEC('SET IDENTITY_INSERT tabA ON')

EXEC('INSERT INTO tabA(colA, colB) VALUES (-2, -1)')

EXEC('SET...