Exporting to excel

  • Thread starter Thread starter bes
  • Start date Start date
-----Original Message-----
how do I export from access to excel?
.
Open the Excel workbook you are going to use
CLick on Data
Point to import External Data
click import data
in the select data source dialog box, click new source
In the data connection wizard click odbc dsn and next
click MS Access Database
click next
In the select database, browse to the file you want to
import and click ok
In Data Connection wizard box, click the name of the
table that contains the data you want to import, and then
click next
Type a name adn description , and click finish
In the select data source, click open
in the import data dialog box, specify where you want to
put the data, and then click ok.
 
Back
Top