FlyerTalk Forums - View Single Post - question about max number of rows in a spreadsheet
Old Jan 30, 2007 | 7:19 am
  #1  
martian
15 Years on Site
 
Join Date: May 2005
Location: here
Posts: 1,832
question about max number of rows in a spreadsheet

So, this may not be the right place to be asking this question. But, I figured someone on here might know the answer. Apologies in advance if I am posting in the wrong forum.

I have a big database of about 1.5 million entries in a .txt files. I need to import them into Excel and turn them into a dbf file. However, Excel will only accept about 60,000 rows. Is there anything I can do to make it accept more rows? Will another program (like openoffice maybe?) do this instead? Or is there a way for me to turn the .txt file straight into .dbf file?

So, again, I realise that this isn't the most appropriate place in the world to ask this question - but flyertalkers are generally a pretty smart bunch and I imagine someone on this forum knows the answer.

Cheers :-:
martian is offline