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)
sourav1295
0
Newbie Poster
Santanu.Das
125
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.
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.