mike55 Posted October 5, 2004 Posted October 5, 2004 Hi all Is it possible to move the data from an access db to a sql db without taking the structure?? Am going to check out the import function myself. Mike55 Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Administrators PlausiblyDamp Posted October 5, 2004 Administrators Posted October 5, 2004 If you have SQL 7 or later you may want to investigate Data Transformation Services - does pretty much what you want. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
*Gurus* Derek Stone Posted October 5, 2004 *Gurus* Posted October 5, 2004 Microsoft Access | Tools | Database Utilities | Upsizing Wizard Save yourself the hassle and move the data into a Microsoft SQL Server database prior to transforming it. Been there, done that. Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.