Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Very large Excel File

I have received a file containing approx 1.5 million records in Excel 2003
format. Excel will open this file but will of course only show 65536 records.
In the past I have used a hex editor to extract blocks of records and then
stitch them back together again afterwards in another application. This file
is too big for my hex editor and it refuses to open it. I have tried
importing into Access, Paradox and Open Office, but all failed. As a last
resort I could go back to the sender and ask them to produce it in a
different format, but the nature of the work means that I need to explore all
avenues before falling back on that option.

All suggestions / assistance gratefully received
--
Stephen L
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
large excel file Miri Excel Discussion (Misc queries) 1 January 15th 07 11:50 AM
Large excel file Jim H Excel Discussion (Misc queries) 0 December 5th 06 04:04 PM
Large excel file [email protected] Excel Worksheet Functions 1 September 29th 06 12:23 PM
File too large for Excel? Bart Snel Excel Discussion (Misc queries) 1 May 19th 05 01:40 PM
My excel file is too large (5 mb) when it shouldn't be, why? Kenview Excel Discussion (Misc queries) 1 February 26th 05 09:14 PM


All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"