Home

Import Fixed Length File to Excel using OLE DB

%3CLINGO-SUB%20id%3D%22lingo-sub-869642%22%20slang%3D%22en-US%22%3EImport%20Fixed%20Length%20File%20to%20Excel%20using%20OLE%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869642%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20load%20data%20into%20an%20Excel%20sheet%20from%20*.txt%20file%20with%20Schema.ini%20by%20using%20Excel's%20Data%20%26gt%3B%20Get%20Data%20%26gt%3B%20From%20Other%20Service%20%26gt%3B%20OLE%20DB%20but%20I%20am%20getting%20an%20error%20saying%20as%20follows%3A%3C%2FP%3E%3CP%3EIf%20I%20used%20Microsoft.Jet.OLEDB.4.0%20Provider%20I%20got%20the%20following%20Error%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3EOperation%20is%20not%20supported%20for%20this%20type%20of%20object%20Error%20Code%3D2147467259%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20702px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133088i5FCEBA9CE2098E77%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22OLEDB.PNG%22%20title%3D%22OLEDB.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20I%20used%20Microsoft.ACE.OLEDB%20Provider%20I%20got%20an%20error%20saying%3A%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3EError%20Message%3A%20External%20component%20has%20thrown%20an%20exception.%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThe%20Connection%20String%20I%20gave%20were%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%3EProvider%3DMicrosoft.Jet.OLEDB.4.0%3BData%20Source%3DC%3A%5CDATA%3BExtended%20Properties%3D%22text%3BFMT%3DDelimited%3BHDR%3DYES%22%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3Eprovider%3DMicrosoft.ACE.OLEDB.12.0%3Bdata%20source%3DC%3A%5CData%3Bextended%20properties%3D%22text%3BFMT%3DDelimited%3BHDR%3DYES%22%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EThe%20Environment%20I%20used%20was%3A%20Windows%2010%201903%2064%20bit%3B%20Excel%202016%20Office%20365%3B%3C%2FP%3E%3CP%3EAnybody%20got%20this%20error%3F%20if%20so%20please%20help%20me%20to%20resolve%20this%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869642%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Hifni Nazeer
Occasional Visitor

I am trying to load data into an Excel sheet from *.txt file with Schema.ini by using Excel's Data > Get Data > From Other Service > OLE DB but I am getting an error saying as follows:

If I used Microsoft.Jet.OLEDB.4.0 Provider I got the following Error

Operation is not supported for this type of object Error Code=2147467259

OLEDB.PNG

If I used Microsoft.ACE.OLEDB Provider I got an error saying:

Error Message: External component has thrown an exception.

The Connection String I gave were:

  1. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DATA;Extended Properties="text;FMT=Delimited;HDR=YES"

  2. provider=Microsoft.ACE.OLEDB.12.0;data source=C:\Data;extended properties="text;FMT=Delimited;HDR=YES"

The Environment I used was: Windows 10 1903 64 bit; Excel 2016 Office 365;

Anybody got this error? if so please help me to resolve this issue.

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies