Access to Excel

Q45 · Apr 21st, 2002, 11:20 AM

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 · Apr 21st, 2002, 08:18 PM

Nobody has any ideas?

John McGraw · Apr 21st, 2002, 08:44 PM

Quote:

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 · Apr 21st, 2002, 08:50 PM

thanks.

gareth · Apr 22nd, 2002, 01:42 AM

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 · Apr 22nd, 2002, 06:11 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 11:20 AM	#1
Q45 New Member Join Date: Feb 2002 Posts: 32	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!

Apr 21st, 2002, 08:18 PM	#2
Q45 New Member Join Date: Feb 2002 Posts: 32	Nobody has any ideas?

Apr 21st, 2002, 08:50 PM	#4
Q45 New Member Join Date: Feb 2002 Posts: 32	thanks.

Apr 22nd, 2002, 01:42 AM	#5
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	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.

Apr 22nd, 2002, 06:11 AM	#6
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	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