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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
What are the steps to fix damaged MDF files in SQL Server? 0
How to export table from outlook into ms access table? 0
ms sql # temp table - invalid object name in data source 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Creation of table in database based upon ado.net database 1
Access Print Files from Query Results 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0

Back
Top