Eprs_Admin
asked on
SQL DB Export
Hi Experts,
I have old databases on my SQL2014 server.
How to export these DB´s into excel file format ?
What kind of settings do I need ?
Needs Excel to be installed on the server to export the data ?
I have old databases on my SQL2014 server.
How to export these DB´s into excel file format ?
What kind of settings do I need ?
Needs Excel to be installed on the server to export the data ?
http://sqlbak.com/blog/export-sql-table-to-excel/
ASKER
The link is cool, but I still have errors:
TITLE: SQL Server Import and Export Wizard
-------------------------- ----
Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE `attAST_AuftragStatus` (
`AST_ID` Lo..." failed with the following error: "The Microsoft Jet database engine could not find the object 'attAST_AuftragStatus'. Make sure the object exists and that you spell its name and the path name correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
TITLE: SQL Server Import and Export Wizard
--------------------------
Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE `attAST_AuftragStatus` (
`AST_ID` Lo..." failed with the following error: "The Microsoft Jet database engine could not find the object 'attAST_AuftragStatus'. Make sure the object exists and that you spell its name and the path name correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
--------------------------
BUTTONS:
OK
--------------------------
ASKER
do I need EXCEL on my server system ?
I think It cant create table attAST_AuftragStatus because table or excel sheet already created.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.