|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Export or import from an MS Access DBGenerally,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 Peter,
AFAIK not in a standard program. It is in the wish list of AdoNet, however. I hope that this answer helps, Cor Show quote "Peter" <zlxm***@sina.com> schreef in bericht news:OpLyWCwRGHA.2088@TK2MSFTNGP14.phx.gbl... > 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 > > > 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 On Tue, 14 Mar 2006 08:48:26 +0800, "Peter" <zlxm***@sina.com> wrote: ¤ 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) > Why don't you just import directly into the Main database using SQL? Yes, I can import the small DB to the main DB using SQL, but I think that> > > Paul 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  |
|||||||||||||||||||||||
Other interesting topics