Connect to Access from Excel

[PedroDC]

I'm almost drowned after so much surfing int the Internet to find help on something:

-> In order to stop using Pivot Tables in Excel, I'm trying to implement accessing an ACCESS Database with VBA. The problem is that I cannot find out how to creat a Macro that accesses the database.

I've seen some general codes, but they all refer to VB and when I paste the code inside the Macro I get errors...


Is it possible to get inside an ACCESS Databse from an Excel Macro and creat a table? This is one of the things I need to do.

Many thanks!

[willakawill]

Hi. I renamed your thread because 'Hello All' will not work in your favor when people search this forum

[willakawill]

In order to use ms access in vba you will need to do a lot of reading especially on ADO objects. TSDN is not a tutorial site so you will have to google 'vba ado tutorial'
Good luck