Daily updates from .mdb to SQL databases.
-
I have a local program that uses .mdb, and I update internet .mdb overwriting the database day by day.
so, i need to do the same but from .mdb to sql database.
what should I do ?
regards,
Martin Gomez.
-
Not sure what you mean, but you can truncate the table and reload it each day.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
Sounds like what you are doing is just over-writing the .mdb "on the internet" with the local .mdb copy that your program uses. Is that correct? It's just a file copy-over?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply