Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How Can I import external data what is more than 65536 lines?

How Can I import external data what is more than 65536 lines? I would like to
import *.csv or *.txt files.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default How Can I import external data what is more than 65536 lines?

Hi,

Buy Excel 2007 or use Miscrosofts workaround

http://support.microsoft.com/default...;EN-US;q120596

Mike

"KurtHan71" wrote:

How Can I import external data what is more than 65536 lines? I would like to
import *.csv or *.txt files.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default How Can I import external data what is more than 65536 lines?

As far as I know, you either need to use Excel 2007 or split the text
file into multiple files and import the data on separate tabs.


For a data file that large a better solution would be to use Access to
analyze your data.

On Feb 14, 3:44 am, KurtHan71
wrote:
How Can I import external data what is more than 65536 lines? I would like to
import *.csv or *.txt files.


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
Import External Data RFJ Excel Discussion (Misc queries) 1 August 28th 06 12:16 AM
Can I go beyond 65536 lines in a file? R.K.Anscombe Excel Discussion (Misc queries) 1 January 31st 06 11:17 PM
Excel should allow more than 65536 lines. mc Excel Worksheet Functions 1 January 19th 06 03:23 PM
Data which is over 65536 lines long KI Excel Discussion (Misc queries) 1 November 16th 05 10:17 AM
Import External Data - XML mklapp Excel Discussion (Misc queries) 0 October 26th 05 07:04 PM


All times are GMT +1. The time now is 04:33 AM.

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

About Us

"It's about Microsoft Excel"