Copy data from txt file (2.2 Million rows) to excel

[Vincent paul]

Hi,

I have a huge text file which consists 22 Lacs rows of data. Need to copy the data to excel. while copying Once the excel copied data till 65000 row it should start to save in new worksheet till EOF.

Have tried available sources in forum and google but nothing works as expected. Any help would be highly appreciated.

 

[JazzSP8]

I book marked this a while back...

https://www.mrexcel.com/forum/excel-questions/69718-text-import-more-than-65-000-rows.html

 

[Vincent paul]

Thanks for the Quick Reply.

Below red highlighted line throwing Error.

'Open an ADO connection to the folder specified
Set oConn = CreateObject("ADODB.CONNECTION")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strFilePath & ";" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""
Error :
Run_time Error '3706'
Provide cannot be found. It may not be properly installed.

Tried, [FONT=&quot]Adding reference for Microsoft Activex Data Objects Library.

Thanks in advance..[/FONT]

 

[JazzSP8]

Ooooooooooh. Then, put simply I don't know - Works fine for me and it isn't code I created, so...

I can tell you that from within the VBE under Tools > References I have;

Visual Basic for Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Object Library

All ticked?

I'm running Windows 7 and using Excel 2010 if that means anything?

 

[JazzSP8]

Did a quick search and found this; https://www.mrexcel.com/forum/excel-questions/640779-run-time-error-3706-provider-cannot-found.html

There are other solutions you can can try by searching for the error code