I have 23 tables I have to upload to a SQL Server development environment. We have encountered a lot of bugs in the migration, so I end up having to do this repeatedly till we get them ironed out. I know how to export one table at a time manually, but I would
like to do this using VBA to make the chore easier.
This is my file DSN I use to connect to SQL
Code:
[ODBC]
DRIVER=SQL Server
DATABASE=MortalityDev
WSID=ABC0010866
APP=Microsoft Office 2016
Trusted_Connection=Yes
SERVER=xxxxxxx,50000
I haven't been able to translate any examples I've found online into workable code.
Thanks in advance.