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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies