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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Link to the Excel spreadsheet as a temporary table, then run a query that
compares it to your ORDER table.
 
Got it! Working just fine! Thank you very much.

Douglas J. Steele said:
Link to the Excel spreadsheet as a temporary table, then run a query that
compares it to your ORDER table.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to track transit time for each step of workflow process? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Filtering DB Call based on local Data 8
Populating related business objects from database 2
Import Named Ranged 7
Autoincrement Key values in Relationships 3
Can this be done in code, or is a change in design required? 1
data ranges don't appear in access import wizard selection box 2

Back
Top