Comment on Q – Run SQL Directly on CSV or TSV FilesComments−ClashTheBunny11yIf you want to just drop CSV files into MySQL, go for it with using the CSV file backing: http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.ht...As the comments say, create the table with a CSV storage backing and then delete the file and symlink any file to the same location. You are now querying your quicken export or your excel file.
Comments
If you want to just drop CSV files into MySQL, go for it with using the CSV file backing: http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.ht...
As the comments say, create the table with a CSV storage backing and then delete the file and symlink any file to the same location. You are now querying your quicken export or your excel file.