ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How Can I import external data what is more than 65536 lines? (https://www.excelbanter.com/excel-discussion-misc-queries/176670-how-can-i-import-external-data-what-more-than-65536-lines.html)

KurtHan71

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.

Mike H

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.


Tim879

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.




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com