how can i import on a excel worksheet data from an access database, not simple information like importing a table, i need more Complex info to import info left join two table with a Criterion to match a field in excel.
somethis like this:
FROM Customers LEFT JOIN CusHistory on Customers .CusID = CusHistory.CustomerID WHERE Customers.CusName)=" & excel (a1) & "
and another point that is important to mention that this access database is locked by a password.
and another point that is important to mention that this access database is locked by a password for example "TEST"
thanks a lot.