Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Getting data from SQL 2008 to Excel 2010

Posted on 2016-08-23
4
Medium Priority
?
24 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

721 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