PureBytes Links
Trading Reference Links
|
Thanks for the note about Yahoo changing "... their download format of the
date from
their old mm/dd/yy format to dd/mm/yyyy format ..."
===================
Re: importing XL data (i.e., Metastock data) into Access
One of the people on the Excel-L List posted this:
"... Access also has a macro recorder. So turn it on,
record your actions, and take a look at your code. BUT, be sure your
version of Access is able to recognize your version of Excel! If not, a
workaround would be to have Excel save the data into a csv or similar file,
and have Access tap into that.
One app I worked on had Excel call Access, and then shut itself off. Access
would know that it was called by code, and would then go to the csv file and
import/process the data. If Access were opened manually, it would simply
behave normally. ..."
==============
So that's the basic pathway .... Metastock data or System Tester into Excel
then into Access.
Sounds like quite a nice package.
Best regards
Walter
|