Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm wondering if there is a way compare data from an Excel file with an Access 2003 database?

I have a list of contacts in an Excel File and also within Access 2003. I would like to know if any of the contacts are duplicated in my list of contacts in Access 2003 or not.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

One way to do the comparison would be to import the Excel data into a new table in your Access database file. Then you could run queries in Access comparing the records in the two tables. Once you are finished with the new table, with the imported Excel data, the table can be deleted.

If the sheet in the Excel file doesn't have column headings in the first row then copy the data onto a new sheet and insert column headings into the first row. This might be easier than assigning column headings one field at a time during the import process. I usually avoid spaces in the column headings that will be used for field names. Access will offer to add a key field and I usually let it...shouldn't matter either way. When you do the import make sure to select the correct sheet in Excel.

Importing data from Excel into Access is easy and it should only take a few minutes. I hope this helps.

share|improve this answer
    
Should it be the same heading names from the Access 2003? –  tintincutes May 3 '11 at 15:02
    
The column names don't need to be same...just something that will make sense. You can always quickly change the field names in Access after you do the import. –  CHarmon May 3 '11 at 15:20
    
How do I run the queries. When you say run queries, do I run it with the new table? or the existing table ? –  tintincutes May 5 '11 at 13:18
    
I already imported the Excel file into Access now I have 2 tables in the access 2007. I also created a query for both. Now how can I compare the 2 tables? –  tintincutes May 5 '11 at 14:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.