-
Run SQL Script File from Access VBA
Hello all,
I would like to run a .SQL file from within MS ACCESS VBA. I have VBA code that moves data to a SQL Server database. I also have an advanced SQL Server script that creates GUIDS and places the data into another SQL Server database. Currently, I run the VBA Code in the Access Database and then open a MS SQL Server Management Console to run the .sql script. I would be great to run the .sql script within the Access VBA code.
Any advice with sample codes would be appreciated.
Thanks,
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
|
|