SQL database to update Access database

[doyouknow]

Hi

I have to create a VB project that goes to a remote SQL server and passes any updates to a mailing list into an Access database on a local machine. Im not sure how to do this. I worked on creating a dataadapter, but Im not sure how to pass this over so it can be inserted into the Access database. Also should I use OLE DB for the connection of both? And if I create an exe file would the computer that uses the application have to have the .NET framework installed?
The 2 databases are set up differently so I would have to get only certain fields from the SQL database and I would have to limit the information to only include data where the an update has occured (using a date stamp field).
Any ideas on the best way to do this? Thanks for any advice.

 

[SkipVought]

Hi,

How about inserting a LINK to your SQL database/table(s) in your Access database. Then you can query based on some date criteria.

BTW, this is not the correct forum for this post. There are many Access & SQL forums.

Skip,

_[red][/red]