Solved

Getting data from SQL 2008 to Excel 2010

Posted on 2016-08-23
4
11 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I found the solution myself
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now