Search results

when I exported the two tables to xml using vba xml export method, access carried every fields in the table; where I only wanted to carry certain fields. I guess access bulit in xml method could not do this feature???? thanks, Bonzai

spikepl, I did try to export the data out both ways: using tables and using query. That's how I know the exact output of the xml data for both ways. When I said "expected" output, I meant the expected output from my customer. Since you know excactly what you need, nothing prevents you from...

spikepl, just want to add another detail: when I create a query an export into xml the xml data structure looks like this <dataroot> <customer> <customerID>9999</customerID> <name>John Doe</name> <address>999abc stret</address> <orderID>89898</orderID> <detail> abcdef</orderdetail>...

spikepl, Thanks for helping me out. I am so glad that you are spending time to review the problem and provide feedback. Here is the detail of my problem. I have an access db with two tables. 1st table is Customer and 2nd is Order. Customer table has 3 fields CustomerD, Name, Address Order...

hi spikepl, I did, I wrote the code to export the tables, but I am stuck with the part where I would like to export only certain fields form the table. here is my code: ----------------- Private Sub Command4_Click() Dim objOtherTbls As AdditionalData 'On Error GoTo ErrorHandle Set objOtherTbls =...

Does anyone know how to solve this problem? I would like to use VBA code to export two tables from an access database into xml format, but in the code, I would like to exclude certain fields (or include certain fields from the 2nd table). Both tables are link with a primary keys of IDNum. (see...

could anyone please help? thanks, bonzai

Hi Dallr, I used your sample codes as reference and I was able to export multiple tables to xml format; however, how could I exclude certain fields or include certain fields from a table? I would like to exclude one field from a table (I do not want to export this particular field), could you...