A Alejandra Parra Jul 14, 2004 #1 Do you know the format of a query to do a... SELECT INTO ..... from an Acess DB to an SQL DB????
A Albert D. Kallal Jul 14, 2004 #2 I believe that you have to link the table first. of course, once the sql server table is linked, then you can just use the standard query builder and build a append query.... So, you have to create the table link first....
I believe that you have to link the table first. of course, once the sql server table is linked, then you can just use the standard query builder and build a append query.... So, you have to create the table link first....
