Synchronise sql data to Access

[Guest]

I am setting up a form on the internet (Rather, having someone set it up for
me). The data returned (Existing clients) will be made available in sql
format.
What is the best way of pulling that data into my Access (2002) database?
Note: the Access database is already set up, the form is yet to be designed.

Any help appreciated.

Graeme

 

[John Vinson]

I am setting up a form on the internet (Rather, having someone set it up for
me). The data returned (Existing clients) will be made available in sql
format.
What is the best way of pulling that data into my Access (2002) database?
Note: the Access database is already set up, the form is yet to be designed.

Any help appreciated.

Graeme

You can link SQL/Server tables directly to Access, provided that the
machine running Access has a link to the SQL server. There are a
couple of ways, but the simplest is to use ODBC. Set up an ODBC link
using Start... Control Panel... Administrative Tools... ODBC
Connections (in Windows XP); then use File... Get External Data...
Link... and select ODBC on the Files Of Type.

John W. Vinson[MVP]

 

[Guest]

Thanks John,
I'll try that out

You can link SQL/Server tables directly to Access, provided that the
machine running Access has a link to the SQL server. There are a
couple of ways, but the simplest is to use ODBC. Set up an ODBC link
using Start... Control Panel... Administrative Tools... ODBC
Connections (in Windows XP); then use File... Get External Data...
Link... and select ODBC on the Files Of Type.

John W. Vinson[MVP]