468,294 Members | 1,953 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,294 developers. It's quick & easy.

Compare Access With Excel Vba Help Please!!!

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
3 1478
FishVal
2,653 Expert 2GB
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
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
2,653 Expert 2GB
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.

Similar topics

5 posts views Thread by Neil | last post: by
3 posts views Thread by James Wong | last post: by
1 post views Thread by Sean Howard | last post: by
reply views Thread by Nadirsha Muhammed | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.