Browsing for data file to import

[Guest]

I would like to import XML data to my DB via a form. Where can I find info on
doing this through a button script? Ideally, the workflow would let me A)
browse for the XML file, B) Import the data directly without going through
the XML import dialog.

Any suggestions??

Thanks!

 

[Douglas J Steele]

For A), see http://www.mvps.org/access/api/api0001.htm at "The Access Web".

For B), I believe you can use the TransferText method. (Unfortunately, I
only have Access 97 installed on this machine, so I can't check, since
Access 97 didn't support XML)