IMPORT DATA FROM SQL ON REMOTE SERVER TO ACCESS

[Simon Gare]

Hi all,

I have a local Access DB which I need to import data from a remote SQL
server once a day, is there any way of doing this automatically?

regards
Simon

--
Simon Gare
The Gare Group Limited

website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk

 

[Sylvain Lafontaine]

If by local Access DB, you mean a MDB database file, then the easiest way to
do this would be to use a linked table but there are other possibilities;
like replication or using DAO or ADO recordsets.

This newsgroup is about ADP, so you should ask in a more appropriate
newsgroup like m.p.a.externaldata or m.p.a.odbcclientsvr.