Hi,

I have tables in MS Access and the same tables in SQL Server.
I want to link the appropriate tables up so that when i update the table in MS Access, it will automatically update the table in SQL Server. I want to do this using an ODBC link.

Anyone with any suggestions of how to go about this?

Thanks

There is no way to do this automatically. Why not just link to the SQL Server tables rather than importing the data?