I hope this is not too off topic. Does any one know of a
methodology to automatically move Access data to SQL Server 2005?
Here is the scenario. The Client is syncing their AS400 to
Access. They want to upload the Access db to the server and then
run a routine to basically purge the tables and repopulate them
with the Access data.
My first suggestion was to just do this manually, Second to
write a CF routine, but then they asked about something at the SQL