windows update uninstal or unable Microsoft.jet.OLEDB.4.0

Ernesto
Ernesto used Ask the Experts™
on
My program do not more importation from exel

how  to restore

Microsoft.jet.OLEDB.4.0

i dont know what happend i suppose there were and update that mess all up
please help !
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Do you have a specific error? Do you mean that it was working a few days ago and not anymore on the same PC?

Author

Commented:
yes eric help!!

Author

Commented:
   MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.jet.OLEDB.4.0; " & _
                                                     "data source='" & PrmPathExcelFile & " '; " & "Extended Properties=Excel 8.0;")
                    MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$] where desciption<>'' and spec<>''order by frac_1 desc,desciption", MyConnection)

                    MyCommand.TableMappings.Add("Table", "Attendence")

Open in new window


thats my coding thing!!
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Do you have a specific error? Do you mean that it was working a few days ago and not anymore on the same PC?

Author

Commented:
just not work no more sudenly, no specific error is the same pc in always run the exel import
Senior .Net Consultant
Top Expert 2016
Commented:
You get an empty table then? Otherwise you have an exception that is being raised when executing that code for sure.

could it be related to the Windows Update of October? https://social.technet.microsoft.com/Forums/en-US/45ebe780-967e-4748-a146-9ec7a15626dc/unexpected-error-from-external-database-driver-1?forum=itmanager

Author

Commented:
yes eric, thats related, tsm as always
regards

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial