[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

stuff



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