Delphi Open save to XML using Microsoft.Jet.OLEDB.4.0 (.mdb)

views:

answers:

Delphi Open save to XML using Microsoft.Jet.OLEDB.4.0 (.mdb)

I have a application with working in access (.mdb) my connection is made using Microsoft.Jet.OLEDB.4.0 and i nead to export a MasterTable and detailtables (1,2,3) to XML is it possible? If it´s possible can i somewhere else (send by email) Open and update or insert into the database? the tables are the same only we are somewhere where it´s not possible to conect into the network where the database is.

Thank´s

You can try to copy your data from your Access Datasets into some ClientDataSets and have them saved as XML.
You can then distribute the XML files to used with the ClientDataSets of your application where there is no connection available. (BriefCase model).
I would strongly recommend reading about ClentDataSets (Cary Jensen's articles for example).

François 2010-08-29 06:09:18

Is there a way to load the data into my dataset ADOTable1.LoadFromFile('c:\test.xml') this way doesn't apply data to my database

re 2010-09-06 21:35:50

hello you can use your adotable to export or import tables in XML format. codes : for export : ADOTable1.SaveToFile('c:\test.xml',pfXML); for import : ADOTable1.LoadFromFile('c:\test.xml');

Sorry for poor english

basooli 2010-08-29 07:58:19

yes it´s that i knead. how can i save and load Masterdataset field´s and detailfields.master.First; while not Mastertable.Eof do beginMasterfield1...............Mastertable.next;end,detail.First; while not detail.Eof do begindetailfield........................detail.next;............detailfiel_1............detailfiel_2Masterfield2............detailfiel_1............detailfiel_2

re 2010-08-29 10:18:53

Hi when i try to ADOTable1.Post; wont work is there another way?ADOTable1.LoadFromFile('c:\test.xml')ADOTable1.UpdateBatch(arall); ADOTable1.Post;

re 2010-08-29 17:07:17

ansaurus

tags:

views:

answers:

Delphi Open save to XML using Microsoft.Jet.OLEDB.4.0 (.mdb)

related questions