How to Read SQL Database in Excel with VBA

Here I show the code and walk through how it works for the excel database reader that we created in an earlier tutorial.

[Markovisch]

Thanks alot, this is very handy and clear :)

[brownbear]

Great tutorial! Is there a way that you can get the column names also displayed in the spreadsheet. How would you load the column names from the database of the table on the VBA.

[arrajmohammed]

thank you sire. can you tell me where I can find the previous video(s) ?

[jrnewport]

Do you need to purchase JET in order to utilize it in the connection string as your OLEDB provider?

[iscgovea]

Can you help me how to do the same but using MS SQL Express 2008?, I am having problems with the recordset

[john-wnyl]

hello How do you connect a * .mdf file?

[krellon]

Yes you can,

You can interrogate a Excel worksheet using SQL commands by connectring to a workbook using Microsoft Jet OLEDB.

gl

[josepyoga]

how to add each type of produce is sold to determine the amount of the remaining goods

[whilburn]

title should be How to read .mdb database in Excel using vba and sql....

[wasimbader]

are you still eating, drink water to digest what ever you just had.