• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 27
  • Last Modified:

Getting data from SQL 2008 to Excel 2010

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
  • 3
1 Solution
Lee SavidgeCommented:
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.
HenrikVangCIOAuthor Commented:
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.

HenrikVangCIOAuthor Commented:
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.
HenrikVangCIOAuthor Commented:
I found the solution myself
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now