I'm trying to copy an MS Access table ("tbl_Review_Step2") into a SQL Server table ("ReviewTable_Step2").
I wrote the following code, which works, but it puts the table into the dbo schema. I'm trying to figure out what to change in order to create the table in a different schema?
SELECT * INTO [ODBC;DRIVER=SQL Server;SERVER=myServerName;DATABASE=myDatabaseName;Trusted_Connection=Yes].[ReviewTable_Step2] FROM tbl_Review_Step2