Rewriting DAO query as ADO
Posted on 2004-09-05
Does anyone happen to know what the ADO equivalent of this DAO query would be?
Database.Execute "SELECT name, address, address2, now as entry INTO [dBase 5.0;DATABASE=C:\DBF].[EXAMPLE] FROM [MyTable],[MyOtherTable] WHERE [MyTable].[id]=[MyOtherTable].[id] AND NOT [MyTable].[Imported]"
This is just a sample, as the actually query is about 7 lines long, but it includes all the elements of the original. I've tried many things, but just one error after another. Many thanks and 250 points to the first person that can help solve this problem!