Getting error while accessing Microsoft Access 2010 file through Import Data task

Asked By adolfojeremiah 10 points N/A Posted on - 10/06/2012

Hi Experts,

While accessing a Microsoft Access 2010 file through Import Data task in SAS Enterprise Guide 5.1, I received the error message. I do not understand this missing Microsoft Office 2007 component.

 

I think it is an awful error message. Have you any idea for this issue. 

 

Please help.

 

Thank in advance.

 

 

The selected file appears to be a Microsoft Access 2007 file. In order to access the file within this file, one of two Microsoft products must be installed on this windows client machine:

 

1. Microsoft Access 2007 (individually, or as a part of a Microsoft Office 2007 suite), or

2. Microsoft’s 2007 Office System Driver

 

The 2007 Office System Driver may be downloaded, free of charge, from Microsoft’s website by going to www.microsoft.com and searching for “Data Connectivity Components”.

                                                      OK

 

• Status: Open
• Question Views: 1053
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by delaaileen

Go To Solution

Best Answer

Best Answer

Answered By delaaileen 0 points N/A #159561

Getting error while accessing Microsoft Access 2010 file through Import Data task

Hello

You get that error due the incompatibility of the used platform from a previous version then you need to install a component to resolve it and to can access to the file, then how the message say you have to download the missing component and for that here is the link to download that missing installation of Microsoft Office 2010:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

I hope that my advices will help you to get through your problem.

About delaaileen

Questions
1

Answers
9

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/19/2012
• Question Category: MS Access

Answered By Nicke Baker 0 points N/A #159562

Getting error while accessing Microsoft Access 2010 file through Import Data task

You may be missing some important Microsoft office components on your system that are required for it to work well.

In order to resolve the issue.

I will suggest that you run the windows update to install any components that are missing from your system for instance .Net framework that is required for the system to work.

Regards,

Nicke

 

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 10/19/2012
• Question Category: MS Access