Copying to WORD
To export data in an ACCESS table to a WORD document, select the rows containing the data then copy it as in WORD (Ctrl+V or copy button). Use Alt +Tab to move to WORD. Open the file into which you want to put the data. Use Ctrl + V or the past button to insert it. In ACCESS v. 2.0 it would be inserted as a table with the fields as column headings. Once the data is in WORD, highlight it the select Table/Convert text to table from the main tool bar.
 

Copying to and from EXCEL
Data can be copied from an EXCEL spreadsheet into an ACCESS database table quite easily. From within ACCESS:

• Select File/Import
• Select Microsoft Excel as the data source
• Select the file which contains the data you wish to transfer.
• Select Import.
• You can import the new data as a new table or add it to an existing one.
• If the first row of the spreadsheet contains column headings, click the appropriate box to insert them as field names.
• A message will appear telling you that the data has been imported.

Data can also be copied from ACCESS to EXCEL:

• Open a new or existing database
• Select File/Export
• Select the Data destination: Microsoft Excel
• Select the object you wish to export
• Select the name and directory and press OK

Importing within ACCESS
Data can also be moved from one file to another within ACCESS very easily:

• Open a new database
• Select File/Import.
• Chose Microsoft Access as the data source
• Choose the appropriate file
• Choose the table, form or query which you wish to import.
• Choose whether you want to import the data or just replicate the structure (i.e. field names and database design elements)
• A message will appear telling you that the data has been imported.

To IT-MA home page
To Department of Historical Studies home page.

(c)R. Middleton 1997. Last modified 30 June 1998.