Can infomration in access update records in an Excel spreadsheet?

[Harley Guy]

We are developing a work evaluation for all of out employees on the shop floor.

While Access is way easier to update and allow for quicker ways to gather information, our requirements is that we must display a training matrix. While access has great reporting features, it is tough to get it a format with all users listed on top, tasks listed on the LH side and knowledge levels showing what level each user is at for each task.

I am limited by standard practice on how to display it so I was curious to know if information updated in Access can be updated on an Excel spreadsheet as well. I know in Excel you can format one spreadsheet to update another but I can't figure out away to have Access do the same thing.



Any ideas?

[June7]

Excel can link to Access tables.

VBA procedure can 'push' or 'pull' data between apps.

The output you want should be achievable with Access report. True, it might be a CROSSTAB query and stabilizing CROSSTAB to run perpetually in a report can be difficult but it is possible. Otherwise, there are other ways to get that report design.

[Harley Guy]

Excel can link to Access tables.

VBA procedure can 'push' or 'pull' data between apps.

The output you want should be achievable with Access report. True, it might be a CROSSTAB query and stabilizing CROSSTAB to run perpetually in a report can be difficult but it is possible. Otherwise, there are other ways to get that report design.

Well, that's way above my knowledge level...is there a place or link that can give me instructions on how to do that?

Thanks!

[June7]

On what - pushing and pulling or building report?

http://forums.aspfree.com/microsoft-...el-413629.html

http://forums.aspfree.com/microsoft-...le-413493.html

http://www.blueclaw-db.com/report_dy...stab_field.htm

[Harley Guy]

Mainly how to push or pull report. I can build the reports and/or query required.

[June7]

You can push and pull data from tables and queries.

You can use OutputTo method to send a report to excel, however, some complex report structures won't output nicely.