A few minutes of your time here and you'll be able to open the text file in Excel and get to work! How To Open Text File in Excel: First Method by embedding text file into excelġ. This article explains how to open text file in Excel using three distinct approaches, so that you may continue your work. A slow project is the result if you don't know how to open text file in Excel. Text files can be made in a variety of applications, but they must be opened in Excel because of the data they contain. Word h as the ability to produce documents with the look and feel of a PDF. Data generation can be carried out in a variety of ways, just like the design of every application for a given purpose. ORS.Open 'SELECT * FROM ' & strFilename, oConn, 3, 1, 1ĪctiveSheet.Range('A1').When working on a variety of projects, you may find yourself needing to open a text file in Excel for a variety of reasons.

'Now actually open the text file and import into Excel Set oRS = CreateObject('ADODB.RECORDSET') 'Extended Properties=''text HDR=Yes FMT=Delimited''' Set oConn = CreateObject('ADODB.CONNECTION') 'Open an ADO connection to the folder specified StrFilename = oFSObj.GetFile(strFullPath).Name StrFilePath = oFSObj.GetFile(strFullPath).ParentFolder.Path Set oFSObj = CreateObject('SCRIPTING.FILESYSTEMOBJECT') 'We need to split this into path and file name If strFullPath = 'False' Then Exit Sub 'User pressed Cancel on the open file dialog StrFullPath = Application.GetOpenFilename('Text Files (*.txt),*.txt',, 'Please selec text file.') 'If the number of records exceeds 65536 then it splits it over more than one sheet.ĭim strFilePath As String, strFilename As String, strFullPath As Stringĭim oConn As Object, oRS As Object, oFSObj As Object 'Imports text file into Excel workbook using ADO. Then run this macro that will convert the text files into excel and automatically, all rows after 65536 will get pasted into the second sheet. Use Access to open it and then copy the rows after 65536 into the second sheet.Ģ.Open and save the file as a text file using 'Notepad'. I can't remember where I got this from, but it works.ġ.

How to open a large text file in excel