There is an upgrade wizard that will take your access data and tables and recreate them in SQL Server. That has been there for at least 3 versions of SQL Server....I believe that was implemented in SQL 2003. So if you are using a version later than that, you should be in luck ;-)
------------------------------------ Three Ravens Consulting Eric Roberts Owner/Developer [email protected] tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com ------------------------------------ -----Original Message----- From: Russ Michaels [mailto:[email protected]] Sent: Monday, August 13, 2012 12:16 PM To: cf-talk Subject: Re: Getting data from MS Access and importing into SQL. it is possible to add a custom interface for msaccess that links it to sql server, so users can do this directly. I don;t know how to do this as I don;t do VBA, but we have a customer that does this very thing. He runs msaccess locally and uses it to conenct to his hosted database and manage data and sync with his local access db On Mon, Aug 13, 2012 at 6:12 PM, Captain Obvious <[email protected]>wrote: > > Maybe this: > > - have end-users upload entire MDB. > - in uploaded MDBs insert links to SQL Server tables. > - execute a set of Insert queries to copy data from MDB tables to SQL > Server tables. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
