ODBC via Excel Choking MS Query

[ddreese]

So just as the title says, I'm looking to play around with creating some queries in Excel to access the database, pull the data in to a specified cell range, and then have it do all sorts of pretty charts and all that junk. I've got everything set up, I just need to get the ODBC working with MS Query.

Let me start by saying it's 'working', I set up the DSN and when I start the process I can see all the table occurances in the Query window. Whenever I go to add one of these to the query, it completely chokes and freezes up. I realize I have a lot of table occurances, and the overall size of the DB is fairly large, but the field list for the table I'm getting at really isn't that big (maybe 60-70 fields).

Has anyone else had this problem? I'm running Office 2k3, and Server 8 advanced. Is there some other 'software' I can use to play with the ODBC connection to rule out it being a filemaker server issue? I've had problems with MS Query being slow before, but not completely freeze up on me.

Any ideas?