Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel Help Needed

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel Help Needed

Old 02-07-03, 09:41 AM
  #1  
DVD Talk Limited Edition
Thread Starter
 
Join Date: Mar 2000
Posts: 5,420
Likes: 0
Received 0 Likes on 0 Posts
Excel Help Needed

I know this can be done but I forgot how to do it.

I have a text file I need to save into Excel that is over 100,000 records.

If you try to open it in Excel, it tells you that the file was not loaded completly because Excel limits you to around 65,000 records.

Does anyone know how to get the entire file into Excel ?

Thanks.
Old 02-08-03, 12:52 PM
  #2  
Senior Member
 
Join Date: Jun 2001
Location: Hail to the Victors!
Posts: 337
Likes: 0
Received 0 Likes on 0 Posts
You might want to import the first 65000 records into 1 excel file, and then the rest into a second one. After this, then copy/paste the records all into 1 file.

Not sure if this will work, but it might.
Old 02-09-03, 01:45 AM
  #3  
New Member
 
Join Date: Aug 2002
Posts: 15
Likes: 0
Received 0 Likes on 0 Posts
There is an Excel limitation of 65536, so i believe there is no way you can import all records to excel in one shot.

I encountered this problem before and I used MS Access to solve the problem.

1. Load your records into an Access table. Access can handle 100,000 or more records.

2. divide your table into 2 by querying the first 65000 records and another query for the next 35000 records.

3. copy and paste the first query to a blank excel sheet or use the export to Excel.

4. copy and paste the second query to another blank excel sheet.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.