i want to create a table from a query of an access db in a vb6 application using sql. what is the proper syntax to do this.
i can get it to delete files in the table by using:
DB.Execute ("DELETE FROM RarTable WHERE [File Type]= 'APPLICATION'")
To create a new table from a query I tried using:
db.execute ("CREATE TABLE TABLE_NAME AS SELECT * FROM TABLE_NAME2 WHERE [File Name] = 'APPLICATION'")
but i keep getting a syntax error.
What is the right syntax....?????