Difficulty getting external data in Access 2007

mimottershaw

Registered User.
Local time
Today, 19:19
Joined
Feb 2, 2007
Messages
40
Hi There,

I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not seem to work in Access 2007. The linked table option now does not permit data entry or amendement. The other "Get external data" options create a table in Access which also does not update my source Excel document. The idea is to enter data in Access using a form. This data is placed in an excel spreadsheet. Excel gets some lookup values, and then enters these in a Word mail merge. Without the functionality of a linked table and data entry, I cannot produce new reports.

Can anybody help please?

Regards

Mark M.
 
Access doesn't support this anymore see here for more info.
 
Thaks for the info Peter. Back to the drawing board I guess!
 

Users who are viewing this thread

Back
Top Bottom