March 25th, 2003, 08:02 PM
Can't get SELECT FROM INTO to work
Neither works for me in VB6. Does VB accept compund statements?
conn.Execute ("Create Table NewTable SELECT * FROM GameInfo")
[syntax error in Create Table]
conn.Execute "SELECT * FROM GameInfo INTO NewTable"
[syntax error in from clause]
March 26th, 2003, 10:15 AM
It has to be valid sql syntax.
The database you are using determines what is valid and what is not.
Not knowing what kind of database you are working with all I can do is suggest another style of statement instead of what you have done.
create table NewTable as (select * from GameInfo)
March 26th, 2003, 12:47 PM
Sorry all, I am using VB6sp5 MS access/jet 4.0, windows XP home
March 26th, 2003, 01:32 PM
as long as you can perform the query in your access client, then you can do the same thing with vb.