Unanswered: linking tables from MS Access and SQLserver
I have a very big and important SQLserver db and a small Student db in a school.
The studentdata is moved once a year to the studentdb and there student can adapt there data.
Now I have to take care of the linking part meaning: the data has to be moved back to the big db for consistency.
How can I do this??
I have absolutely no idea cause I'm a newbie.
In the SQL Server Enterprise Manager, there is a wizzard for importing and exporting data. It is very straight forward, you just ned to pick your souce and destination and hit finish. Otherwise you could create a local DTS package which will do this for you.. You should be able to find a quick tutorial on the web.
Not much detail here but should point you in the right direction.