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

[merlin777]

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?

 

[oldbrewer]

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]

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]

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.

 

[merlin777]

thanks guys