| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How big can files be to import to excel, and is there a rec limit?
I am having problems importing a very large .csv file into excel and keep
getting an error message saying that the file is too big. What's up with that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How big can files be to import to excel, and is there a rec limit?
Hello, The worksheet limits on Excel a 65,536 rows by 256 columns. If your csv has more than 65,536 lines of text in it that is most likely your problem. You could either get a program to split your file into chunks or do it with an Excel macro and then import the chunks into separate worksheets. -- FastLiveHelp Database, website, and application developer ------------------------------------------------------------------------ FastLiveHelp's Profile: http://www.excelforum.com/member.php...o&userid=31779 View this thread: http://www.excelforum.com/showthread...hreadid=515165 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How big can files be to import to excel, and is there a rec limit?
There are 256 columns and 65536 rows in any excel worksheet.
How many lines/fields are in your .csv file? MHayashisan wrote: I am having problems importing a very large .csv file into excel and keep getting an error message saying that the file is too big. What's up with that? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How big can files be to import to excel, and is there a rec limit?
from a previous post by Norman Jones
http://support.microsoft.com/?kbid=272729 "MHayashisan" wrote: I am having problems importing a very large .csv file into excel and keep getting an error message saying that the file is too big. What's up with that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with import files by excel macro | Excel Discussion (Misc queries) | |||
| problem with import files by excel macro | Excel Discussion (Misc queries) | |||
| Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
| How do I import Names of Windows files into an Excel Spread sheet | Excel Worksheet Functions | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
