import information for matrix tracking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kris - 31 Dec 2004 17:39 GMT

I was wondering if anyone knows how to import information from various
different sources into access so I can spit out some matrix tracking reports.
Once I have that mastered I would like to put as much automation into it as I
can. Any suggestions? Some of the things I will be pulling information from
is web base queries, a problem ticketing system (Peregrine) and a home made
real time user request system (Oracle).

Reply to this Message

John Nurick - 31 Dec 2004 18:45 GMT

Hi Kris,

Access can use pretty much any data source for which there's an ODBC
driver, including Oracle databases. If Peregrine uses an ODBC-compliant
back end, well and good; otherwise just export the relevant data to text
files that Access can import. For information from the web, it's usually
best to download a text file or Excel workbook, but Access can (within
limits) import tabular data from HTML files, and Access 2003 has useful
XML capabilities.

If that's not enough, you can write VBA code to read data in custom
formats...

>I was wondering if anyone knows how to import information from various
>different sources into access so I can spit out some matrix tracking reports.
>Once I have that mastered I would like to put as much automation into it as I
>can. Any suggestions? Some of the things I will be pulling information from
>is web base queries, a problem ticketing system (Peregrine) and a home made
>real time user request system (Oracle).

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message