Copying result into a table

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I do an sql query on an access table and save the result in a new
table in the same access database?

I am using vb.net.

Thanks

Regards
 
Use OledbCommand object to execute "INSERT INTO....SELECT FROM ...." SQL
statement
 
Thanks. Would this overwrite the "new" table if already exists? This is what
I want.

Thanks again

Regards
 
Back
Top