Automation of queries 's results in Excel document

Hello all,

I'm a newbie in Access... And before starting to explore this
software, I would like to know if it's possible to automate everyday
queries result in Excel .

If it's possible can you give me the step to do this ?

Thank u,

PS: Sorry for my bad english :$

re: Automation of queries 's results in Excel document

On 5 avr, 14:39, "Belgarath" <Fay.Matth...@gmail.comwrote:Oops I ve forgotten to precise i'm talking about automation of export
in excel ...

re: Automation of queries 's results in Excel document

On Apr 5, 8:44 am, "Belgarath" <Fay.Matth...@gmail.comwrote:
Are you asking if is it possible to output the results of a query to
Excel?

re: Automation of queries 's results in Excel document

On 5 avr, 15:42, "Matt" <mdw233...@yahoo.comwrote:Yes I am but Is it possible this output be automatically ?

re: Automation of queries 's results in Excel document

On 5 Apr 2007 06:52:56 -0700, "Belgarath" <Fay.Matthieu@gmail.comwrote:
Yes, but you don't export from Access. You import in Excel.
Start a new blank Excel spreadsheet.
In the menu bar click Data
then Get external data
then Create new query.

Let the Excel query wizard create the query you will need to import data from
an Access database. Follow the instructions in the query wizard.

Every time the new spreadsheet you have just created is opened, the data from
the Access database you have chosen is automatically updated in Excel.

I don't remember if any changes in the Excel data is reflected back to the
database. Be careful !!

Chuck
--