Importing text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing txt csv files into Excel greater than 65k lines 1
MATCH() or VLOOKUP() across mutliple 65K sheets possible? 4
How can I surpass/modify the Excel limit of 65k rows? 1
Opening Large Spreadsheet 2
Row Limit 65536 6
Pivot Table - 3
Excel Capacity 3
I want to actually reduce the number of rows & columns in a worksh 3

Back
Top