Automate the database connection in Excel

[caierhui]

Is their a way to automate the database connection in Microsoft Excel, instead of clicking Data > From Other Sources > ODBC > etc... ? I have no knowledge of VB so if you can provide a link or youtube please do so.

[event21]

Hi -

Yes, you can use ADO or DAO whichever you prefer. Just google it.

Regards,
event

[caierhui]

I tried searching ADO which will connect with ODBC, but the codes i saw didn't have the username, database name, password etc. how do i add that?

this is the link i got.
http://www.java2s.com/Code/VBA-Excel...eddatabase.htm

Hi -

Yes, you can use ADO or DAO whichever you prefer. Just google it.

Regards,
event

[event21]

Hi -

What database are you using?

These are all you need.

http://www.connectionstrings.com/

Regards,
event

[caierhui]

Solved this. Thank you