Reading data from access 97 into Sql
Hi all,
What is the best method to move data from an access database into sql server database with different table and field names?
If possible could you give me an example?
Thank you so much!
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Master BillaPosted Aug 11, 2009, 4:35 AM
Yes you can use the import/export tool in sql server
this very easy and faster way to do this to data migration
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm
thank you