Registered: Jun 2006
08-22-12 06:13 AM
Quote from lordoftrades:
I have worked a lot on VBA in Excel, and would like to test how the result would be if I used SQL instead of hundreds of .csv files.
But I have no clue on how to create a SQL database from all my .csv files. I have searched up and down without finding any answers that is relevant.
Does anyone have suggestions on how to create a database in SQL from all the .csv files. I guess they have to be separated into EOD and Intraday?
If using Microsoft SQL Express 2012 (free), use Import/Export Data (xx-bit) tool to bring csv straight into your database.
and yes, you will have seperate tables for intraday and EOD. Then you can use SQL queries through VBA and/or outright SQL queries to do what you want with the data...