Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Getting data from SQL 2008 to Excel 2010

Posted on 2016-08-23
4
Medium Priority
?
25 Views
Last Modified: 2016-08-28
When trying to get data from SQL 2008 to Excel 2010 with the attached ODC file i have one PC that fails (all other PC's works)

The PC reports back :
Data could not be retrived from the database
Check the database server or contact your database administrator. Make sure that the external database is available, and then try the operation again.

The pc is a newly installed Windows 7 professional and the Excel 2010 is version 14.0.06023.1000 (32-bit)

Thanks in advance
Henrik
ag-sql-AX2009Prod-CUSTTABLE.odc.txt
0
Comment
Question by:HenrikVang
  • 3
4 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 41766512
Sounds like you may need to install the Access Database Engine for your version of Office. Search google for it and choose the right one for your version of Office.
0
 

Author Comment

by:HenrikVang
ID: 41766530
Hi Lee

The full Access 2010 was allready installed on the PC- but i downloaded the engine and applied it to my system

did not help - same error.

cheers
0
 

Accepted Solution

by:
HenrikVang earned 0 total points
ID: 41766744
Found the solution - we deleted the users profile on the PC.

We have replicated this issue - it happens when we transfer the users profile via Windows Easy Transfer.
0
 

Author Closing Comment

by:HenrikVang
ID: 41773594
I found the solution myself
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question