Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: Docmd.TransferText / Import XML?

    I'm building a simple import feature for a database, that so far allows the user to import 2 types of files, either a semi-colon separated text file or an excel spreadsheet.

    But, as the users are international and most of them non-profit, I need an option to import XML files.

    How would I go about this, using a functon similar to docmd.transfertext? None of the filetypes for docmd.transferspreadsheet, docmd.transfertext or docmd.transferdatabase seem to allow imports of XML files?

    Thanks for any any help,

    Cheers, Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    Application.ImportXML
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2005
    Posts
    183
    Brilliant! Thanks a bunch.
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •