I want to replace some data in a large table (Table A: 4.5 million records) with some new data I have uploaded in Table B. I'm using an Access Data Project.

I want to write a delete query which will delete from Table A those records which appear in Table B. I'm sure this must be possible, but when I draw up the query vanilla Access style, it brings up the "Delete Table Dialog Box" and requires that only one table be selected, preventing me from creating the relation with Table B.

This is real basic stuff, but I'm afraid I'm quite stuck here!

Thanks for your help

Andrew

I found a couple of links in the end that helped solve the problem quite easily

http://www.windowsitpro.com/SQLServe...8808/8808.html

http://www.sqlservercentral.com/colu...theeasyway.asp

Cheers!

Andrew