Updating Access DB from Excel Macro

jonsan

New Member
Joined
Jan 19, 2005
Messages
3
I need to update multiple Access tables in a single database from an Excel macro. I do not need to see any of the data or put it into a spreadsheet. I intend to use an SQL Update query. I know how to write the SQL query, but I do not know what type of connection and objects to use. All help is extremely appreciated.

J
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

jonsan

New Member
Joined
Jan 19, 2005
Messages
3
Any short examples or links to sites with the information would be greatly appreciated. I searched through the forums here and did not find a code example.

J
 

Forum statistics

Threads
1,181,788
Messages
5,932,051
Members
436,816
Latest member
Composh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top