Hi all, 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 level. Any thoughts are welcome. Thank you, Michael ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4