Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How Can I Use Vba To Connect To A Sql Server?

April 26, 2017Connect SQL Server VBA

0

Posted

How Can I Use Vba To Connect To A Sql Server?

1 Answer

0

Posted

I want to use VBA to connect to a SQL server and run a SQL command that will return data to a pivot table. The SQL command will be generated based on a date range entered into a couple of cells (at least that is my first thought on how to do this). My goal is to have the user be able to enter the date range, click refresh, and the the pivot table will be updated with that data. I’m somewhat new to using visual basic in Excel so I’m not really sure where to start at this point. I’m sure I haven’t given out enough information at this time and I apologize for that. Any help is greatly appreciated!