-
Solved: Excel Code Efficiency with DB Connection
I already have a MS Access DB with queries stored within it. As of now with my code within Excel, I'm creating an ado connection, creating a recordset, and using a SQL string to populate the recordset. Is there anyway possible to just run the query already saved in Access to populate a recordset in Excel. I find that my excel code is beginning to look sloppy with all this SQL code thrown in there.
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