Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

ODBC via Excel Choking MS Query

ddreese
in Importing & Exporting

Featured Replies

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?

Create an account or sign in to comment

https://fmforums.com/topic/57298-odbc-via-excel-choking-ms-query/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.