Changing from Replica Id

[rohbe]

I exported a table from SQL Server to Access and the Export Utility took one of the Columns and defined it as a Integer Replica ID. I can not either paste data from this column nor export the table to Excel. Anyway to get around this.

Thanks,
Jean

 

[Darrylles]

Hi,

I've been told that you have exported from a SQL Server REPLICA table - not the MASTER table.

If not possible from MASTER, then produce a link table to the SQL Server table and then create a 'Make table' query in Access to 'duplicate' the linked SQL Server table.

Hope this helps.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk