Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Access 2010 : Exporting Information (part 2) - Exporting to XML Files

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
1/1/2012 6:25:51 PM

Exporting to XML Files

You can export tables, queries, forms, and reports from Access in an XML format that can be used by other applications. Clicking the XML File button in the Export group on the External Data tab displays the Export wizard, where you specify the destination location and assign a name. Clicking OK displays the Export XML dialog box, where you can do one of the following:

  • Select the Data (XML) check box to export the data.

  • Select the Schema Of The Data (XSD) check box to create a separate .xsd file containing the structure of the .xml file.

  • Select the Presentation Of Your Data (XSL) check box to export an XLS Stylesheet that describes how to display the XML data.

Tip

To export a table as a combined data/schema file, in the Export XML dialog box, click More Options, click the Schema tab, click Embed Schema In Exported XML Data Document, and then click OK.

When you click OK, the object is saved with your specifications, and the Export wizard gives you the opportunity to save the export steps. You can then view the tagged .xml file in Internet Explorer and the .xsd file in any text editor.

In this exercise, you’ll export an Access table to another Access database and to an Excel workbook. Then you’ll export the table as both a formatted and an unformatted text file.

Set Up

You need the GardenCompany10 database you worked with in the preceding exercise to complete this exercise. Create a blank database, and save it as Exported. Then open the GardenCompany10 database, and follow the steps.

  1. In the Navigation pane, under Tables, click Suppliers.

    We are going to export the entire table, so there is no need to open it first.

  2. On the External Data tab, in the Export group, click the Access button.

    image with no caption

    The Export – Access Database wizard starts.

  3. On the wizard’s first page, click Browse.

  4. In the File Save dialog box, navigate to your practice file folder, click Exported, and then click Save.

  5. In the Export – Access Database wizard, click OK.

    The Export dialog box opens.

    Set Up

    You can export the table’s structure and data or only the structure.

  6. With Suppliers displayed in the Export Suppliers to box and Definition and Data selected in the Export Tables area, click OK.

    Access exports the selected table.

  7. On the Save Export Steps page, click Close.

  8. In Windows Explorer, navigate to your practice file folder and double-click Exported.

    Tip

    You can open only one database at a time in a single instance of Access. If you open a second database without first closing the one you are working in, Access prompts you to save recent changes and then closes the first database before opening the second. To open two databases at the same time, start a second instance of Access from the Start menu, and then open the second database from the Backstage view. You can also double-click the database file in Windows Explorer.

    The Exported database opens in a separate instance of Access 2010.

  9. In the Navigation pane, under Tables, double-click Suppliers. Then verify that the table exported correctly, and close this instance of Access.

    Now suppose you need to provide the information in the Suppliers table to someone who doesn’t have access to the database. Let’s export the same table as an Excel workbook.

  10. In the GardenCompany10 database, open the Suppliers table in Datasheet view. Then on the External Data tab, in the Export group, click the Excel button.

    image with no caption

    The Export – Excel Spreadsheet wizard starts.

  11. On the wizard’s first page, click the Browse button. Then in the File Save dialog box, navigate to the practice file folder, and click Save.

    The File Name setting reflects your specifications.

    Tip

    By default, the spreadsheet has the same name as the table it’s based on and will be saved in Excel Workbook (*.xlsx) format.

    Tip

    You can change the name and format in the File Save dialog box, or you can edit the name and select a different format in the wizard.

  12. Select the Export data with formatting and layout check box and the Open the destination file after the export operation is complete check box. Then click OK.

    Access exports the table to an Excel workbook. Excel starts and opens the workbook.

    Tip

    The Suppliers table has been exported to the Suppliers sheet in the workbook.

    Troubleshooting

    The appearance of buttons and groups on the ribbon changes depending on the width of the program window.

  13. Close the Excel workbook, and then on the Save Export Steps page of the Export – Excel Spreadsheet wizard, click Close.

    Suppose you want to make the data in the Suppliers table available in Outlook. You can’t export directly to Outlook, but you can export the data from Access to a text file and then import it into Outlook. Let’s export the text file now.

  14. With the Suppliers table open in Datasheet view, on the External Data tab, in the Export group, click the Text File button.

    image with no caption

    The Export – Text File wizard starts.

  15. With the path to your practice file folder displayed in the File name box, change the default file name from Suppliers.txt to Suppliers_fixed.txt.

  16. Select the Export data with formatting and layout check box and the Open the destination file after the export operation is complete check box. Then click OK.

    The Encode ‘Suppliers’ As dialog box opens.

    Troubleshooting

    From here, you can select the encoding format options you want.

  17. With the Windows option selected, click OK.

    Access exports the table as a formatted text file. Your default text editor starts and opens the Suppliers_fixed text file.

    Troubleshooting

    Access has separated the rows and columns of the table with dashes and pipe characters.

  18. Close the text file, and then close the wizard without saving the export steps.

  19. Repeat steps 14 through 18 to export the table again, but this time change the name to Suppliers_delim.txt, and don’t select the Export data with formatting and layout and Open the destination file after the export operation is complete check boxes.

    The Export Text wizard starts.

    Troubleshooting

    This wizard will guide you through the process of setting various options.

    Tip

    You can experiment with different wizard options, moving as far as the last page before backing up and trying a different approach. At any point, you can click Finish to accept the default settings for all the wizard’s remaining options.

  20. Switch between the Delimited and Fixed Width options, noticing the difference in the data in the Sample export format box.

  21. With Delimited selected, click Next.

    The options on the wizard’s next page vary depending on whether you are exporting a delimited or fixed-width file.

  22. Leave Comma selected, select the Include Field Names on First Row check box, and click Finish.

    Access exports the table as an unformatted text file.

  23. Close the wizard without saving the export steps.

  24. Start Windows Explorer, navigate to your practice file folder, and double-click Suppliers_delim.

    The exported text file opens in your default text editor.

    Tip

    The delimited text file, displayed in Notepad.

Clean Up

Close the text file, Windows Explorer, and the Suppliers table. Retain the GardenCompany10 database for use in the last exercise.

Other -----------------
- Microsoft Project 2010 : Saving a Set of Columns as a Table
- Microsoft Project 2010 : Adding and Removing Columns in a View
- Metadata and Power Searches : Setting Properties When You Save & Personalizing Searches
- Metadata and Power Searches : Working with File Properties
- Tracking Your Licenses with the Key Management Service (part 2) - Configuring DNS to Let KMS Clients Find the KMS Server
- Tracking Your Licenses with the Key Management Service (part 1) - Installing and Initializing KMS
- Taking Advantage of Volume Licensing : Choosing the Right Volume License Key for Windows
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF I/O Model (part 2)
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF I/O Model (part 1) - I/O Request Handler
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF Object Model
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer