Convert MS Access Database Files to MetaStock Data Files
If you select the “MS Access database file to MetaStock” option, following dialog will appear:
First, you have to specify one ore more database files that you want to convert to MetaStock. Afterwards, you have to select whether the price records of all securities are stored in one table, or a separate table for each symbol exists. If all securities are stored in on table then you have to enter the name of the column that contains the security names or symbols.
If your database is locked with a password you have to tick off the option “Database is locked with a password”. Afterwards, you have to enter your user name and password.
Secondly, you have to define the fields that are available in your database file. Tick the checkboxes corresponding to the data field which you want to include. You can change the field order using drag & drop.
If your table looks like the table in Figure 5 then you have to tick off the fields “Symbol”, “Date”, “Open”, “High”, “Low”, “Close”, “OpenInterest”, “Volume”.
It does not matter if the fields have other names than “Open”, “High” etc. You can give them any name you want. It is only important that you have selected all fields that are available and that they are in a correct order.
Finally, you have to specify a directory where the MetaStock files should be stored. To start the conversion process, click on the “Start conversion” button. After the process has finished you can use any program that supports MetaStock format to read the MetaStock files created by Convert2Database.