Exporting help needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Fred,

Start by creating a query in Access that returns just the records and
fields you want. Then export this query to Excel.
 
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.
 
Back
Top