Exporting help needed

F

fred

Hi,
I have an existing database which i need to export data out of to an excel spreadsheet. I need to search for an entry, retrive certain fields, then transfer to excel. I need each entry to appear in excel under each other so i think that i need some kind of append query from what i gather, but am not sure how to tackle it??!!
Any help much apreciated!
 
J

John Nurick

Hi Fred,

Start by creating a query in Access that returns just the records and
fields you want. Then export this query to Excel.
 
O

onedaywhen

I need each entry to appear in excel under each other

Sound like you may need to use the SQL keyword UNION in your query.
Look it up in the help.
 

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

Need Help with Macro Security 1
Merging from an Excel file with graphics 1
Need help merging Excel into Publisher Booklet w 2 columns 0
VBA - exporting serial letters to single documents 0
Copying Portions of Data 0
Need Help with a VBA subroutine 0
Need to export a query to Excel, add data to it and have Excel upd 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top