McPain

yes I tried this as well. After refresh the DGbrid show the old data, so no update is happening to the database.

yes the data is inside the file up2date, but when I refresh the old data from the DB come in. My goal: - enter data into Dbgrid - save into XML - load data from XML to present data inside DBgrid

why a "insert into" when the DBgrid is permanently connected to the database? The link I got but do not really understand how to add this to my code or processes.

Hi all, I am using Dbgrid with FDquery and have a connection to an MDB database. I can access and save data, all good. Now I am trying to export the data via fdquery.SaveToFile('Filename.xml', sfAuto ). The procedure is creating an XML file. Also fine. How can I read in (import) this data again? When I try this: fdquery.LoadFromFile('Filename.xml', sfAuto ); fdquery.Edit; fdquery.Append; fdquery.UpdateRecord; I get all data into the DBgrid, but the data is not getting saved into the MDB. What do I miss? Thx! Alexander