?Describe how to import and export data from Microsoft Access tables.

Question

What will be an ideal response?

Answer 1

?Answers will vary. You can only import data that is in the form of a list-a series of paragraphs or worksheet rows that contain related data, such as product names and prices or client names and phone numbers. Before you import the list, you should check the format of the data. The first row of data will become the field names in the new table, so it is important that every column have a heading. Each row of data becomes a record in the database, so there should not be any rows above the column heads and there should not be any blank rows. Once you have prepared the worksheet, you can start Access and import the data into an existing table or to a new table. To do this, you click the Excel button in the Import & Link group on the External Data tab to open the Get External Data - Excel Spreadsheet dialog box.?You need to click Browse to select the file to import. To import the data into a new table in the database, keep the Import the source data into a new table in the current database option button selected. After you click OK, the Import Spreadsheet Wizard starts. In the first dialog box in the wizard, you need to select the worksheet that contains the data you want to import. The data in the selected worksheet previews in a table at the bottom of the dialog box. In the second dialog box in the wizard, you specify whether the first row in the worksheet contains headings. The headings will become the field names in the Access table. After you make this specification, click Next in the next two dialog boxes to accept the defaults. In the last wizard dialog box, you can specify the name for the Access table.?Recall from your work with Access that you use a query to extract information from a database. The query results are stored in a datasheet. You can export the query results to a new text document or Excel worksheet. Now that the query is created, you can export the results to a text file. To export to a text file, you can choose the Text file type, which creates a document with unformatted text, or Rich Text Format (RTF), a text format that preserves the formatting and layout of data. Please see the section "Importing and Exporting Data" for more information.