use an access database as a source of data in excel?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
I have a number of users that need to enter data into excel on and off during the day and view the results of theirs and and others' data. At the end of the week i produce a coplex set of reports.

Excel's sharing ability is too poor for this but it is the easiest way for me to crunch the data for the reports.

Can I use access for entering data and displaying it and then get my excel workbook to use the access data for the reports?

I realise it could all be done in access but I'm an access newbie and I'll find it far easier to do my reports in excel.

Would this be possible?
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
write an access query and export it to excel - I had this set up when I worked for London Underground (the metro) the database had millions of records each with 50 odd fields. It put the data into a nominated page, overwriting what was there and all our pivot tables and charts drew on this daa
 

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
thanks for that. Is this the same as running a workbook and having it import the data from access? My users are not IT savvy so I'd like the automate it for them if possible.
 

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,430
Office Version
  1. 365
Platform
  1. Windows
Can I use access for entering data and displaying it and then get my excel workbook to use the access data for the reports?

Yes, very easily. On the Data tab use the "From Access" button to set up a data connection and import your data.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,466
Messages
5,528,972
Members
409,848
Latest member
Blomsten
Top