if your looking to move off access then Microsoft also provide free migration tools as well.
On Mon, Aug 13, 2012 at 8:18 PM, Eric Roberts < [email protected]> wrote: > > 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:352140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
