Sample Data for the "Hiding Duplicate Values" Series

Mike Wolfe -

This article is Part 0 of my "Hiding Duplicate Values" Mini-Series.

Sample Data

If you would like to follow along with the other articles in this series, you can do so by downloading the sample data in XML format:

Customer.xml

Instructions for importing the data are available here: Importing XML Step-By-Step.

Use XML to Share Access Table Data and Avoid Internet Warnings
Anti-virus software and Microsoft policies make it harder than ever to share table data among Access users. The XML format is a simple way to avoid those roadblocks.
No Longer SetMike Wolfe

Step-by-Step Instructions

Reproduced here from the above article for your convenience:

  1. Open the database where you want to import the XML data in Microsoft Access.
  2. Click on the 'External Data' tab in the Ribbon at the top.
  3. In the 'Import & Link' group, click on 'New Data Source', then hover over 'From File'. A dropdown menu will appear; select 'XML File'. This starts the Import XML Wizard.
  4. In the 'Get External Data - XML File' dialog box, browse to the location of the XML file that you want to import, select it, and click [OK].
  5. Access will analyze the XML file and provide you with import options. Since you're importing a table from a third-party, select the 'Structure and Data' option. This will create a new table based on the data and structure in the XML file.
    • (_) Structure Only
    • (•) Structure and Data
    • (_) Append Data to Existing Table(s)
  6. Click [OK] in the 'Import XML' dialog box after confirming the above setting.
  7. Access will import the XML data and display a dialog box when the operation is complete. Click [Close] to close the dialog box.
  8. The imported data will now be available in the newly created table in your database.

If all goes well, this is what the XML import screen should look like in Step 5:

Acknowledgements
  • Sample data generated with the help of ChatGPT