|
|
You Can Export a table or query to a spreadsheet. Select a table or query in the Database window before choosing File, Save As/Export (in Access 97), or Export (in Access 2000). If you're using Access 97, choose An External File or Database and click OK (this step is unnecessary in Access 2000). Next, click a spreadsheet format from the Save As Type box. Use the Save In box to designate a drive and folder for the exported data. Enter or choose a spreadsheet name. Then, click Export (in Access 97) or Save (in Access 2000).
|