joining disperate databases

  • Thread starter Thread starter SL
  • Start date Start date
S

SL

Hi!

I have been trying to produce a report in excel using ms query, but
not getting very far...

I have a MySQL database on an exernal server that contains a product
database. I can access this using e.g.

SELECT products_0.products_model, products_0.products_quantity
FROM catalog.products products_0

I also have a local MS Access database containing lists of products
sold,

SELECT Items.Description, Items.End
FROM `C:\some\folder\data`.Items Items
WHERE (Items.Description Like '%sgele010%')
ORDER BY Items.End

What I would like to be able to do is :
for each products_model, report the last data ("End") in Items where
it was sold, or indicate if it was not sold.

If they were different tables in the same database, it seems this
would be easy. How can I do it when they are from such different data
sources?

Thanks in advance for any help...

Rob
 
Hi
I would try to link one of the tables either in MS Access or MySQL so
that you only have to access one datasource. This should be easier than
accessing two different data sources in Excel
 
You can't JOIN tables that are in spearate databases. Look in your
documentation (e.g. MS Jet help files) for the SQL 'FROM' clause.

Your best bet may be to link to the MySQL table using the MS Access
GUI (although you can achive the same without MS Access). This will
enable you to JOIN the tables in a Jet query.
 
Back
Top