Link to home
Start Free TrialLog in
Avatar of Eprs_Admin
Eprs_AdminFlag for Austria

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 ?
Avatar of A Karelin
A Karelin

Avatar of Eprs_Admin

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
------------------------------
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
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial