Creating/Updating Excel 2003 sheets from Access 2003

[mikeg8]

I'm new to Access, Excel and VBA. I'd like to create (if not already existing) a named Excel sheet and then populate certain cells in it with certain data from a record in an Access db. I realise that what I want to do is not best suited to my beginner status, but that's just tough on me: it is the task I have been set!
Can anyone point me towards info here or elsewhere which would help me on this? I've searched the FAQ's and previous posts, but I haven't found anything yet.

Thanks in advance

Mike

 

[SkipVought]

Hi,

Must the data be PUSHED from Access to Excel?

Can it be PULLED into Excel From Access?

Skip,
[sub]
[red][/red]
[/sub]

 

[mikeg8]

Skip:
I was thinking that it had to be PUSHED from Access into Excel, but it could be PULLED by Excel from Access. Either way, the data will always exist in Access first.

Mike

 

[SkipVought]

Its quite simple to pull data from a database using MS Query, via Data/Get External Data/New Database Query...

Once a QueryTable has been inserted on a sheet, it can be refreshed anytime, thereby retrieving fresh data from the database. No code required in most cases.

Skip,
[sub]
[red][/red]
[/sub]