I am looking for some sensible suggestions on data management tools for large data files.
I have been experimenting aith excel and access only to find that access has limitations on import files size which caught me off guard.
I've been looking at dbase and some other out of the box solutions, but just hoping to find something that best fits my needs.
My typical data processing procedure is as follows:
Import large .txt files in common, pipe or other common delimited formats.
Run queries on the data once imported such as merging cells, and
Export my final queries into MySQL format...
The tables I am dealing with are millions of records large and as I said Access can no longer handle them..
Thanks for any ideas or suggestions on the best software for the job.