Does Excel ORDER_ID in Orders named range exist in ORDER Access ta

[jjgray]

I would like to check a single column within a named range in Excel for
potential key violations prior to TransferSpreadsheet. Ex: Does ORDER_ID in
Orders named range exist in ORDER Access table?

Any suggestions would be appreciated.

 

[Douglas J. Steele]

Link to the Excel spreadsheet as a temporary table, then run a query that
compares it to your ORDER table.

 

[jjgray]

Got it! Working just fine! Thank you very much.

Link to the Excel spreadsheet as a temporary table, then run a query that
compares it to your ORDER table.