Excel data to SQL server Loading

349 Views

Hi ,

I am getting below the error . Can you please explain me how to resolve this error?

|Data flow DF_EDS_ADC_MMAP_CLAIMS_IB|Reader FF_EDS_ADC_MMAP_CLAIMS_IB1

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <'Sheet1$' is not a valid

name. Make sure that it does not include invalid characters or punctuation and that it is not too long.>.

(14.2) 09-27-16 12:34:06 (E) (3420:5192) EXL-300873: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB|Reader FF_EDS_ADC_MMAP_CLAIMS_IB1

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <Operation is not allowed

when the object is closed.>.

(14.2) 09-27-16 12:34:07 (E) (4104:5876) RUN-053003: Zero divide error. Divisor is equal to zero.

(14.2) 09-27-16 12:34:10 (E) (4520:3332) EXL-300875: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB

Could not access Excel file

<//tc-ftp/FTP-Site/test/KKapadia/WR_Conversion/Sprint_8/ADC_MMAP_Claims/Incoming/TEST_OmniSYS_Abbott_Medicare_08_31_2016.xls>

(14.2) 09-27-16 12:34:10 (E) (4520:3332) EXL-300873: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <Could not decrypt file.>.

Thanks,

krish.