ODBC setup, SQL server & Excel VBA

Hi,

Can someone help me digest what the following code does? I'm new to SQL & Excel integration.

Please Login or Register  to view this content.

This is an example taken from the Internet. Is this step always needed?

Thanks

Hi

Try the below code to connect your sql database via excel . I use the below code to get the data from database.

FOR THIS CODE TO WORK
In VBE you need to go Tools References and check Microsoft Active X Data Objects 2

Please Login or Register  to view this content.

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.