What I think I need to do is create an ODBC connection between a computer that has the Access file and the computer running the SQL Server.

Microsoft has posted a preview release of its new SQL Server ODBC Driver for Linux, which enables access to Microsoft SQL Server databases from Linux operating systems.

You can use SQL to create, modify, search, and display database information. Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server.

This driver enables the Linux machine to connect to the MSSQL server. Once the driver is installed, you can configure an ODBC connection on your Linux machine to use the driver, which then allows a ...