access and excel

  • Thread starter Thread starter antonov
  • Start date Start date
A

antonov

hello, my boss wants me to produce an excel sheet at the end of the month.
this sheets contains data which I have in access. I would like to know if it
is possible (and how) to export only the data needed (the data has to go on
rows and not every day has data.....)
thanks for any help
 
Create a query that contains the data you need. On the Access Menu select
File | Export. From the file type chose Excel.
 
Well, there are a few ways to do this.
1) Export out the query/table. Right-click on the file, select export, save
as Excel
2) Run the query, click Tools | Office Links | Analyze with Excel
3) Create a query and copy and paste into Excel
4) Excel Automation through Access. This page has sample code
http://www.mvps.org/access/modules/mdl0035.htm
 
You must log in or register to reply here.

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

Similar Threads

access or excel 2
Exporting Tables/Queries 21
Access #Error & Excel Pivot 0
Import data from excel into access tables 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Macro to copy a row to another sheet based on date 0
Exporting Data from access and appending to an existing excel sprd 3
Excel VBA - Problem with Closing Print Preview 0

Back
Top