Synchronise sql data to Access

G

Graeme at Raptup

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
 
J

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
Click to expand...

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]
 
G

Graeme at Raptup

Thanks John,
I'll try that out

John Vinson said:
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]
Click to expand...
 
Top