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

You should be able to import the text file directly into your database and not have to worry about excel.

You definitely can't expand excel to handle 1.5 million rows. Access will do it, if for some reason you need it in the Microsoft suite.

Excel 2003 and earlier versions have a maximum of ~60,000 rows. Excel 2007 can handle up to ~1 million rows, which is still quite short of what you need.

MS Access can handle it easily.

A quick Google search ...

http://www.sql-server-performance.co...?TOPIC_ID=2681
http://www.topshareware.com/DBF-Conv...load-41734.htm

If you anticipate your database growing much, you might want to consider using SQL Server instead of Access. You can download the SQL Server 2005 Express edition to play around with for free.

http://msdn.microsoft.com/vstudio/express/sql/

Good point. If you're good with databases, go with SQL Server. If you kind of need an idiot's database, (like me), Access works ok.