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,