If you really want an automated way to get Vantage data to Access, the only
way is ODBC. You can get the driver (which is a third party product from
Merant) from Epicor tech support. It will come with instructions that won't
help, but you can get good instructions from Epicor tech support.
Be careful not to expect too much from this approach. You will be able to
attach to the Vantage files, and most of them will allow browsing, sorting,
querying, reporting, etc. But, there are two problems that I have run into.
The first is a bug that will blow away your ODBC connection to the Vantage
database if you browse too quickly. When this happens, the user will have
to exit Access and re-open it. Sometimes, they will have to reboot. The
second is a bug where Access won't display the data from certain files.
JOBPROD is one example that I know of, but I also know there are others.
You can query against JOBPROD, and, in a linked query with other tables, you
will get the correct results, but the data from JOBPROD will not display as
data. The data will look like "#Deleted". I have contacted tech support
about these issues, with no acceptable response. In fact, they claim to not
be able to reproduce the errors. However, there have been other postings on
this list that would suggest that these problems are occurring throughout
their customer base.
From: Danny Spell [mailto:danny.spell@...
Sent: Friday, January 12, 2001 8:14 AM
Subject: [Vantage] Getting Data Out of Vantage
What is the best way to get data out of Vantage? I need an automated
way of pulling data of multiple Vantage/Progress DBs into an Access
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)