vba - Excel to access

[noidea23]

Hii, i need help in using macro to compare values in a column of an access table against a value in the excel spreadsheet. If the value matches then macro will do something to that particular row of access data.

E.g.

For each row in access_Table_X
If recordset.Fields(10).Value = Sheets("1").Range("A1").Value Then
cut and paste entire row of recordset in access_Table_X to recordset_Table_Y

Any help will be greatly appreciated!

 

[Micron]

You don't say which app you want to do this in or if table Y is in the same Access db. Personally I'd probably link the sheet to Access as a linked table then look for the value in the linked sheet. If found, run an Access query to copy from one table to the other (i.e. an append query). However, I'm not a fan of copying records into other tables and having the same data in two places. An exception would be if the source tables are linked (such as ODBC tables) that cannot be edited by the db user and need to be.

If you're going to do this from Excel instead, I guess you'll need to use Automation. Here's where I go if I need code for that:

EXCEL Import And Export

 

[noidea23]

Thanks for your reply!
btw Table X and Y are different tables in the same Access
and the macro will be in Excel where Sheets("1").Range("A1").Value is in