Member Avatar for gayzlein

I want to create a table in my database Access from another table already existing with vb.net
this is my query:
CREATE TABLE table_name SELECT as PRODUCT_NAME, PRICE FROM TABLE1 GROUP BY PRODUCT_NAME
if someone can help me I would be grateful

Edited by gayzlein
  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by ryanjayson
Member Avatar for ryanjayson

For Same Database use:

SELECT *  INTO NEW_TABLE FROM SOURCE_TABLE

For different database use:

SELECT * INTO DEST_DB.TABLE_NAME FROM SOURCE_DB.SOURCE_TABLE_NAME

It will copy both schema and data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.