Solved

Getting data from SQL 2008 to Excel 2010

Posted on 2016-08-23
4
14 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

939 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

4 Experts available now in Live!

Get 1:1 Help Now