Oledb exception on Azure Cloud.

Problem scenario:

“Microsoft.Jet.OLEDB.4.0” provider for read data from the excel file and add data to data table. It work fine on local, but when hosted on azure cloud App service it generate error.

Reason:

The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only.

Work around:

Use DocumentFormat.OpenXML dll for Excel manipulations.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s