Re: Work With Off-Line Data

[Jake Yazici]

Dan-

I scoured the internet to see if someone more experienced had written about this. it looks like Miscrosoft DTS software may be a solution. Also, the "mysqlimport" program could be useful.

Check this link:
http://dev.mysql.com/doc/mysql/en/mysqlimport.html

Pay attention to the --replace flag.

This is relatively easy to do via ADO.NET's disconnected dataset objects, however, that's not a feature of Access. I'll dig around some more.

-Jake

"I conclude that there are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies and the other way is to make it so complicated that there are no obvious deficiencies." - C. A. R. Hoare