How can I read over than 65,536 rows from excel spreed sheet

[Lillian]

I have microsoft access file call meters.mdb, when I look at the one of
table, it was 136,636 rows, but when I import to excel spreed sheet, it only
can read up to 65,536 rows, can I can read the whole data, because I need to
import this excel spreed sheet to SQL server.


Thanaks.

Lillian

 

[JMB]

Use wordpad to open the file and cut/paste the data to create multiple files
or see

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

In either case, the data will be split among multiple worksheets if you
bring it into excel. The next version of excel will have more than enough
room for what you want, but I don't think it comes out until next year.

 

[ANdras]

Hi,

do you really have to intermediate with Excel? because, i believe, SQL
Server could be "fed' with the database.
Best regards,
ANdras
(Hungary)