hi is there someone that can give me some hints on how to create excel file using data from my ms access database..because i haven't seen one in the net maybe someone might help me here..i would appreciate some hints or tutorials..:D thanks a lot...

4 Years
Discussion Span
Last Post by Stuugie

In Excel when you take the "File ... Open" menu option you can change the file type to Access database. The next step is to select a data source such as a table or query. Then you see the database table in Excel. Very easy.


Not really exporting; you don't necessarily have to do anything in Access. So I guess it is more like importing your Access data into Excel.

Try it:
In Excel, open a file.
A file selection dialog appears.
Change the file type to "Access Databases".
Select the Access database you want.
You may get a security warning. Click Enable.
A "Select Table" dialog appears. This lists available tables and queries.
Select the one you want & click OK.
The Access data is then displayed in Excel.

If you want to you can write a query in Access to provide just the data you require and then open that query in Excel.

Votes + Comments
Exactly right!

You don't need Crstal Reporting for this. It's as easy as clicking the Data tab and then "From Access" and then follow the prompts.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.