what is an easy way to import data from sql server database ?

Question

what is an easy way to import data from sql server database ?

Answer 1

what is an easy way to import data from sql server database ?



You can do this in Access by linking (or just importing) to the source files required in SQL server via the ODBC driver connection method. See http://www.about-access-databases.com/importing-data.html for more Information on how to do this.



Then you will be able to use Access queries to analyse the fields and records using SQL or the design grid. See http://www.about-access-databases.com/access-queries.html for help on all types of queries.



Good luck

Ben Beitler

Answer 2

It is better you download it to microsoft access, then it will be easy work with it.



thank you

Answer 3

you need to use sq. Server's utility to Export records to a diverse sq. Server or an option is which you will take backup of your database from one server and restore it at yet another one!

Answer 4

You can link to an external data source within Excel. Its under Tools.



You will need an ODBC definition back to the SQL Server with the appropriate credentials.



From there, you can create a pivot table or basically do whatever you want. Beware of the 65k row limit in older versions of Excel.



Exporting to MS Access is also an idea. Just link the tables in Access back to your SQL Server db and perform the appropriate make table queries in Access. Beware of the 2Gb. file size limit for MS Access.



Good luck.

Answer 5

use tool d-softs database compare

www.d-softs.com

Answer 6

If you can access SQL Server, why not just use it? SQL code is far more powerful than any spreadsheet could ever be.

Answer 7

SQL Server comes with an Import/Export utility that allows you to export data in pretty much any format you want, including ASCII delimited (which will then get picked up by Excel). You can also use Access as others have suggested, but the Import/Export utility is pretty intuitive and fast.