Devam Ediyor

Monitor Microsoft Access Database and Export Data as XML


I'd like a small script for Windows which monitors a MS Access database table. When new rows are added (new inventory items) with a set value, this triggers an automatic export of the new rows (new inventory items) in XML format.

For example, when a new row (inventory item) is added, the script looks at that row's "ItemNotes" column. If the value of the "ItemNotes" column is "web" or "Web", then this triggers certain column values (ProductName, ProductPrice, etc. etc.) from the entire row to be exported in XML format. The XML file will be saved in the same location every time, and replace the previous XML file.

Each instance of the XML file must represent the entire inventory, which means that any rows with an "ItemNotes" value of "web". Preferably, this would be done by editing the XML file to add new rows, and remove rows of items that have been sold since the last trigger event.

Thanks in advance for your time.



Beceriler: Microsoft Access, Windows Masaüstü, XML

Daha fazlasını gör: with monitor, microsoft access web database, example of inventory database, access export xml file, monitor access, trigger access database, ms access 2010, xml export, windows automatic, time monitor, MS Access Database, inventory database, export, export data, c# with access database, c with access database, alan, access microsoft, access database, access d, small data table, 2010 access, added database, database example, inventory value

İşveren Hakkında:
( 5 değerlendirme ) San Francisco, United States

Proje NO: #737992