Share this Page URL

Chapter 3. Getting Information Into and ... > Exporting Information to Other Progr... - Pg. 69

Getting Information Into and Out of a Database 69 The two date fields that were imported, OrderDate and ShippedDate, are displayed in the format yyyy-mm-dd. They were also imported as text rather than date values, which would make it difficult to use them in queries to find orders placed between specified dates. 11. Close the Order Details table. Leave the Orders table open. 12. Click the View button to switch to Design View. 13. Change the Data Type for OrderDate and ShippedDate to Date/Time. 14. Click the Save button to save your changes. 15. Return to Datasheet view. The dates are now displayed in a more conventional format, and can be manipulated as dates. CLOSE the GardenCo database. Exporting Information to Other Programs You can export Access database objects in a variety of formats. The specific formats available depend on the object you are trying to export. Tables, for example, can be exported in pretty much the same formats in which they can be imported. Macros, on the other hand, can be exported only to another Access database. The following table lists the export formats available for each object: Object Table Export formats Access, dBASE, Excel, HTML, Lotus 1-2-3, Paradox, Text, SharePoint Team Services, Active Server Pages (ASP), Microsoft Internet Information Server (IIS), Rich Text Format (RTF), Word Merge, XML, Open Database Connectivity (ODBC) Access, dBASE, Excel, HTML, Lotus 1-2-3, Paradox, SharePoint Team Services, Text, ASP, IIS, RTF, Word Merge, XML, ODBC Access, Excel, HTML, Text, ASP, IIS, RTF, XML Access, Excel, HTML, Text, RTF, Snapshot, XML Access, Data Access Page (DAP) Access Access, Text Query Form Report Page Macro Module Tables and queries can be exported to most versions of the listed formats. Forms and reports are more limited, but even so, exporting to the formats you are most likely to use is pretty straightforward. The ones that get a little tricky are Active Server Pages (ASP), Microsoft Internet Information Server (IIS), and Open Database Connectivity (ODBC). In this exercise, you will export the Suppliers table from the GardenCo database in a format that can be used by Excel. Then you'll export the Customers table to an XML document. Tip To complete this exercise, you will need to have Excel 97 or later installed on your computer.