ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing text file (https://www.excelbanter.com/excel-discussion-misc-queries/81369-importing-text-file.html)

Jeff

Importing text file
 
Hi,

I have a text file that is over the number of rows = 65K. So is there any
way to import the first 65K rows and then the next rows?

I tried importing the text file into acess but it did not work.

Thanks for your help.

Kevin B

Importing text file
 
You can open the file in Notepad and then split up the file by cutting rows
from the source file and pasting them into a target file. I would create a
backup of the original data file and then proceed with splitting the data
over multiple files.
--
Kevin Backmann


"Jeff" wrote:

Hi,

I have a text file that is over the number of rows = 65K. So is there any
way to import the first 65K rows and then the next rows?

I tried importing the text file into acess but it did not work.

Thanks for your help.



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com