import information for matrix tracking

[kris]

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]

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...