T
tread
I have an Access Database with on Table that has 2.5 MM records
containing: ID, Ticker, Date, Price.
Objective:
Create a script to Query the Table by Date and Export the query to a
text file, one file per day with the file name = date (e.g. query all
tickers and prices for 04/01/1998, and generate a 040198.txt file). I
have to do this for 6 years worth of prices, and it's too time
consuming to generate each file one at a time.
Thanks in advance for your help!
Trevor
containing: ID, Ticker, Date, Price.
Objective:
Create a script to Query the Table by Date and Export the query to a
text file, one file per day with the file name = date (e.g. query all
tickers and prices for 04/01/1998, and generate a 040198.txt file). I
have to do this for 6 years worth of prices, and it's too time
consuming to generate each file one at a time.
Thanks in advance for your help!
Trevor