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 :-: