How to add table to old database and then copy the data to it.
Printable View
How to add table to old database and then copy the data to it.
Hi,
You can use a "CREATE TABLE" statement from vb to create your table in your old database, then use an "INSERT INTO" statement to copy all the data into your table. If the data is coming from another database then connect to this database, create a recordset to hold all the data, then use a for loop to loop through all the records.
HTH,
Preeti
Hi,
I am working with Ms-Access2000, with VB6.
I am having two identical database in two different folders with same name, and identical table name with similar structures.
eg:
1. D:\ABC\Fabric.mdb
2. D:\NEW\Fabric.mdb
the first data base consists of data, where as second one consists of empty tables...
Here... I want to dump the data of selected tables of ABC folder's Fabric database to NEW folder's Fabric database.
I thought of 2 ways....
1) first reading the data of table1 and using INSERT command putting each record to NEW folder's Fabric database...
(like this i have to go on reading the records... from selected tables and put in the correspoinding table1 in NEW folder's Fabric database)
2) Deleting the 'table1' from NEW folder's Fabric database... and simply copy the 'table1' from ABC folder to NEW folder...
in the second model i am not clear that how to copy an existing table from on database to another database.
or
is there any way to create new table in required (NEW) database from existing database(ABC)... (like in Oracle Create table emp1 as(Select * from EMP)).... in this case first CREATE part should be done in NEW database... and SELECT part should be done at ABC database...
please help me....
thanks in advance...