ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sql vba applications (https://www.excelbanter.com/excel-programming/370630-sql-vba-applications.html)

AD108

sql vba applications
 
I have been working with VBA for a little while now. I would like to
continue on by learning how to access my SQL server. (retrieving data into
excel and importing data from excel back to the server)

Any suggestions on where to start learning?

Thanks in advance.



NickHK

sql vba applications
 
Look into use Excel's QueryTables on a worksheet or VBA and ADO.

NickHK

"AD108" wrote in message
...
I have been working with VBA for a little while now. I would like to
continue on by learning how to access my SQL server. (retrieving data

into
excel and importing data from excel back to the server)

Any suggestions on where to start learning?

Thanks in advance.






All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com