By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,835 Members | 1,488 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,835 IT Pros & Developers. It's quick & easy.

Compare Access With Excel Vba Help Please!!!

P: 3
Hi everyone, i`m trying to make access interact with excel in vba

I have an excel sheet with 3 columns and 30 rows, and an access table of 4000 rows.

The idea is to compare every row of the excel from only one column with every row of my access table from only one column of the same type.

For examle:
My excel has 3 columns: Code, Name, City.
My access table has 4 columns: Code, Name, City, Country.

I want to compare every "Code" of my excel, with every "Code" of my access to find the matches IN ACCESS.

If any could help me with this I would be very very pleased!!
Aug 10 '07 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi everyone, i`m trying to make access interact with excel in vba

I have an excel sheet with 3 columns and 30 rows, and an access table of 4000 rows.

The idea is to compare every row of the excel from only one column with every row of my access table from only one column of the same type.

For examle:
My excel has 3 columns: Code, Name, City.
My access table has 4 columns: Code, Name, City, Country.

I want to compare every "Code" of my excel, with every "Code" of my access to find the matches IN ACCESS.

If any could help me with this I would be very very pleased!!
Hi, there.

You can just link Excel table to your db, and use it in Access queries.
Aug 10 '07 #2

P: 3
Thank you there!, Ok supose now I have two access tables, how do I compare in vba the column1, row 1 of TABLE A, with all the rows of column 1 of TABLE B, then column 1, row 2 of TABLE A with all the rows of column 1 of TABLE B, and so on..this is to find the matches between both tables and make an operation each time there is a coincidence.

Hope you can help with this one!
Aug 10 '07 #3

FishVal
Expert 2.5K+
P: 2,653
Thank you there!, Ok supose now I have two access tables, how do I compare in vba the column1, row 1 of TABLE A, with all the rows of column 1 of TABLE B, then column 1, row 2 of TABLE A with all the rows of column 1 of TABLE B, and so on..this is to find the matches between both tables and make an operation each time there is a coincidence.

Hope you can help with this one!
Build a query. SQL expression is the following.
Expand|Select|Wrap|Line Numbers
  1. SELECT [TABLE A].*, [TABLE B].* FROM [TABLE A] JOIN [TABLE B] ON [TABLE A].[Column1] = [TABLE B].[Column1];
  2.  
Aug 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.