|
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!!
| |
Share this Question
| 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.
| |
|
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!
| |
| 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. -
SELECT [TABLE A].*, [TABLE B].* FROM [TABLE A] JOIN [TABLE B] ON [TABLE A].[Column1] = [TABLE B].[Column1];
-
| | | |  Question stats - viewed: 1340
- replies: 3
- date asked: Aug 10 '07
| |
