Member Avatar for sourav1295

Hi guys.
I have access database and i am looking to import only selective few tables(based on checkbox selection) into a new database.I got the table names required and the data in datatable. The problem is i am not able to figure out how to move the data into a new table in another database(root path is known).Please help. Thank you in advance.
(Any other approach is also appreciated)

  • 2 Contributors
  • 1 Reply
  • 88 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Santanu.Das
Member Avatar for Santanu.Das

You can do it by using SQL Statement.
Assume that you have two identical tables. To transfer One's data to another, the SQL statement is as follows

Insert Into NewTableName Select * From OldTableName

It can transfer all data from OldTable To NewTable.

Edited by Santanu.Das
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.