Urgent: Linked Tables - converting current tables to linked tables - automatic update?
Posted on 2007-07-24
Hi i am using access 2003,
I have a database with a lot of tables. I have been searching for a way for a user to easily update these tables themseleves from excel files. This way a user could update tables from the client point. I have been searching and can not find a simple solution to this problem. I guess using linked tables would be the easiest way. So i will create excel files at a server location. The user will just have to update data there than. Will my linked files update automatically? How do i convert my current tables to linked tables?
If you have a better idea, i am open to suggestions. This is very urgent. This must be implement by the end of the week.