Excel and Access

Q

Q45

New Member
Joined
Feb 17, 2002
Messages
32
Is there an easy way for MS Access to pull the statistical information from Excel and to have Excel read the data entered into and MS Access database?
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
If I understand you correctly, try the following:

In Excel, the 'Data' menu contains an option to 'Convert to MS Access', whilst Access has the option to 'Analyse with MS Excel' is in the 'Tools' menu, under 'Office Links'. You can also import or link to data in Excel from Access, via the file menu, under Get External Data.

Hope this helps
Stuart
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Looking for Help to create an Excel or Access Database
Replies
5
Views
83
Micron
M
D
  • Solved
Force IMAGE To Connect
Replies
3
Views
140
Davey54
D
G
  • Solved
VBA Ref: Is there a way to check if "Trust access to VBA project object model" option is checked using VBA?
Replies
2
Views
206
gifariz
G
W
  • Solved
Sheets("Sheet1").Activate crashing VBA code
Replies
3
Views
328
Skyybot
Skyybot
L
  • Question
Draw data from website
Replies
2
Views
67
Lux Aeterna
L

Forum statistics

Threads
1,214,634
Messages
6,120,659
Members
448,975
Latest member
sweeberry

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top