Exporting to excel

G

Guest

-----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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top