Connecting Access through Excel VBA

[Ranjith S]

Hello, I want to connect to access table through excel VBA and pull data from Access table into Excel. I am not clear on the coding I need to use from Excel VBA to connect to access tables.

Can someone let me know the coding for the same. thank you.

 

[Fazza]

Welcome, Ranjith

Suggest you google as there are MANY examples on line. Such as ADO Excel VBA - SQL Connecting to Database Example Macros
which I found by googling the same as the thread title, "Connecting Access through Excel VBA"

If that (linked site) isn't to your liking, please try one of the other ones. Regards, Fazza

 

[Ranjith S]

Thank you Fazza, it was really helpful.

I will get back for any further clarification.

 

[Ranjith S]

I gone through the link which you provided, which was very helpful.
ADO Excel VBA - SQL Connecting to Database Example Macros
When I tried to replicate this in excel VBA, I am getting data source name too long. I dont know how to fix it.

 

[Fazza]

Maybe check the provider (& connection string)?
Here is a simple example from another site Much ado about ADO | Excel Matters
Again, google is your friend
If you're stuck, please provide full details of situation.