Please Help Newbie...Migrate Access .MDB to Sql
Please assist me , i'm new to sql and need to migrate a access db to sql format.
i.e "lastname", firstname", "email", etc...any assistance would be great.
I'm trying to get this working so as i can send out "personalized" letters, emails, froms.
Cheers,
Monica
If all you need to do is move the database to SQL Server, the Upsizing Wizard in Access is your friend. Load up your Access database and then go to Tools... Database Utilities... Upsizing Wizard... Follow the steps and it will move your database (both data and schema) to SQL Server.
Word of caution - The Upsizing Wizard isn't going to improve your database design. If you have a poorly normalized Access database, you'll end up with a poorly normalized SQL Server database. Those of us who work seriously in databases tend to hand create the new schema in SQL Server and then write a DTS package to transform the data appropriately.
