Importing Over 65536 Rows

I

ibnu

Greetings,
I am using MS Excel 2002 SP2 on Windows 2000 Pro SP4
computer. I have a .CSV file that has 76,000 rows, and
each row has 5 columns.

When I click on Data -> Import External Data -> Import
Data from the menu to import data from the .CSV file to an
Excel Worksheet, I get a message saying "The text file
contains more data than will fit on a single worksheet.
To continue and import as much of the data as will fit,
click OK. You can then import the rest of the data by
repeating the import operation on another worksheet and
using the Text Import Wizard to exclude data already
imported". I then click the "OK" button.

When I try to import the remaining data on .CSV file to
the next Worksheet, I type 65537 in the "Start import at
row:" field of the "Text Import Wizard" window. When I
click the "Next" button, I get a message saying "Integer
is not valid".

In the "Start import at row:" field of the "Text Import
Wizard" window, the largest valid integer/number that I
can use is 32767. If I type any number larger than 32767,
I get the "Integer is not valid" message.

Could someone please advice me on how to import a .CSV
file that has 76,000 rows (with each row has 5 columns) to
Excel Worksheets?

Thank you.
 
I

Ibnu

Thank you very much for your prompt reply Ron.

I have tried the solution below. Unfortunately, it only
works for a text file. In other words, it only works if
the file has only 1 column per row. After the import, all
data from the .txt file will be placed on Column A on the
Worksheet(s).

My .CSV file has 5 columns per row. After importing
the .CSV file, each row on the Worksheet(s) should have
Columns A, B, C, D and E filled as well.

Thank you.
-----Original Message-----
Maybe

http://support.microsoft.com/default.aspx?scid=kb;EN- US;q120596
XL: Importing Text Files Larger Than ???? Rows


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ibnu" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Excel And Notepad 3
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Import more than one .csv file into the same Excel file. 1
dowloading data of CSV file to excel file 2
Excel 2003 data import wizard does not support line ends in fields 0
Cell data entering slow! 0

Top