-
VBA [Excel 2007] to SQL Server [9.0]
Hi All,
I have seen many forums with similar posts, however, I have not come across a reply that works.
Systems Overview
- Excel 2007
- SQL Server 9.0
Process Overview
- Have established a SQL View (sql query that is published without parameters) which is outputs to Excel via External Data Source via SQL Server menu.
- SQL View outputs 400,000 rows every time I run the query into Excel via "External Data Source" via "SQL Server"
Request
1. Require VBA code to paramterise the SQL view on selected fields; or
2. VBA code to establish an parameter query through an ADO/DAO connection, build the query and output the results to Excel sheet.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules