Data Management

[vmgautam]

Hello all,

I have this data (first name, last name, address, city, state, zipcode, email, etc.) its a very large database 80-90 million, I need assistance and help on how to manage such a large database using excel.

Whats the best way to sort and manage the database ....

Thanks in advance.

[shg]

That's too large for Excel; you need a database program like Access.

[vmgautam]

The data I have is not in one file, there are 100's of smaller files, I tried importing a file in access, it seems to be quite slow ...

More help needed

[shg]

I tried importing a file in access, it seems to be quite slow ...

Wait til you try to put 90 million records into Excel ...

[vmgautam]

Thanks, can you recommend any custom/paid solution to this ...

[shg]

Try posting your question at Ozgrid.com/forum. They have more database people over there, I think - carlmack in particular. There is also a paid forum that has been started recently.

Good luck!