Re: Import MS access data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Kathie,

The actual ODBC driver should allow you to do any valid SQL query that creates a result set. You should be able to as many joins as you want. I've joined up to six tables at a time with that driver and the results were correct.

The queries you make using Excel and MS Query are completely independent of any queries that are in the .mdb database.

So that task at hand is to try to figure out why you're getting a crash when you try to join the tables.

You get good data when you make single table queries. I take it that you've looked at the results to make sure there isn't something screwy in one of the tables, such as a letter where a number is expected, or a date where text is expected, or a null character when there should be an empty cell.

That leaves us with doing standard troubleshooting stuff as a starting place.

Here's a list of things to try in order. After each suggestion one try to make a join and see what happens.
http://mcgimpsey.com/macoffice/office/troubleshooting.html

The steps may or may not cure this problem, but either way please post back and let us know how it turns out.

-Jim Gordon
Mac MVP



Kathie D. Baxter wrote:
I have Excel 2004 on Mac OSX. I'm working in a primarily PC environment.
We have a database on the network that is in MS Access. I've found a Mac
program called Actual ODBC that allows me to use Excel and Query to pull
that data up on my Mac. However, the way the database has been created,
there are people's names and phone numbers in one table, and their addresses
in another table. The common field in each table is an Address ID number.
I've tried using a join in Query to combine the data, but it always freezes
up and crashes on me.

I can pull the data in each table into separate worksheets in Excel, but
have addresses without names and names without addresses and have to scan
through the 2 sheets to find which address goes with which name.

Does anyone have experience with this? Is there a better program than
Actual? is there some limit to the amount of data I can expect it to deal
with? Is there some workaround in Excel that will enable me to combine the
data in the two worksheets?

.

Quantcast