Export or import from an MS Access DB

[Peter]

Hi,

Generally,a database will become bigger and bigger day after day. Some time
I want to take some records from the main DB to compose a small DB, in
another time I may want to get the small DB back to the main DB.I call these
as "Export" and "Import".

That is
1. Export a small DB from the main DB
2. Import the small DB to the main DB,the small DB will have no change in
structure

Now I have finished the "Export" by making some query ,creating a new access
DB and inserting records to it. I'm wondering how to finish my "Import".
Can I query the small DB and using DataAdapter to fill a DataSet and then
Update to the main DB?

Thanks in advance,

Peter

 

[Cor Ligthert [MVP]]

Peter,

AFAIK not in a standard program. It is in the wish list of AdoNet, however.

I hope that this answer helps,

Cor

 

[Peter]

Sorry,Cor, I'm wondering what is the wish list of AdoNet.

Peter

 

[Cor Ligthert [MVP]]

Sorry,Cor, I'm wondering what is the wish list of AdoNet.The list with what is wished, but what is going everytime to next version

(That is not only by Microsoft by the way)

)

It has attention from more persons at the moment to try to make it from a
wish a solution.


Cor

 

[Paul Clement]

¤ Hi,
¤
¤ Generally,a database will become bigger and bigger day after day. Some time
¤ I want to take some records from the main DB to compose a small DB, in
¤ another time I may want to get the small DB back to the main DB.I call these
¤ as "Export" and "Import".
¤
¤ That is
¤ 1. Export a small DB from the main DB
¤ 2. Import the small DB to the main DB,the small DB will have no change in
¤ structure
¤
¤ Now I have finished the "Export" by making some query ,creating a new access
¤ DB and inserting records to it. I'm wondering how to finish my "Import".
¤ Can I query the small DB and using DataAdapter to fill a DataSet and then
¤ Update to the main DB?
¤

Why don't you just import directly into the Main database using SQL?


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Peter]

Why don't you just import directly into the Main database using SQL?

Paul

Yes, I can import the small DB to the main DB using SQL, but I think that
will spend my lots of time. My DB contains 12 tables. For all these tables,I
have to query the small DB,get records and then insert or update them to the
main DB. It will save me many time if I can use a DataAdapter to fill a
DataSet with the small DB and then update the main DB.

Peter