SELECT INTO Statement issues

I double checked the connection string, and the ";" is needed after the pw, at least it works when I run:

sSQL = "SELECT * INTO Orders_tbl FROM "

sSQL = sSQL & "[odbc;Driver={SQL Server};Server=" & sqllocation & ";Database=" & sqlname & ";Uid=" & sqlun & ";Pwd=" & sqlpw & ";].Orders_tbl WHERE Status = 'ORDERED'"

Thank You for the reply.

From my understanding the SELECT INTO statement will create the Order_Details_Backup_tbl with the same columns and data types from the source tables, which in this example are both big int.  The INSERT INTO statement would need the table already created and it would then append the records to that table.  At least this is how I see it working when I have no joins.  The SELECT * INTO will copy and create the exact column structure and data types in the destiation table.  Ideally all I really want is all the Order_Details_tbl columns copied to the Order_Details_Backup_tbl, but because I only want the order details of the orders that have a status of "ORDERED", I need a relationship column, so I have added Orders_tbl.OrderNumber to the query.  Maybe I am goig about it wrong.