Access to Excel

[Q45]

How do I link an Access Database to Excel so I can calculate some statistics and then convert it back into Access again so I can create a report with those calculations? Thanks!

 

[Q45]

Nobody has any ideas?

 

[John McGraw]

On 2002-04-21 19:18, Q45 wrote:
Nobody has any ideas?

I dont... But wait till monday. You'll probably get alot more people looking at your message then. (from what I can tell, most people read this board from their workplace )

 

[Q45]

thanks.

 

[gareth]

I am sure it can be done friend.The way I normally do it is,when I extract excel to access,I would put it in form view and just export it back to excel.Hope i've been of assistance to you.

 

[klb]

From Excel, use Get External Data to get your data from Access.

Name the range where you do the calculations for your statistics.

In Access, link to your named range.

Good luck