Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Crash when filtering import to Excel Expand / Collapse
Author
Message
Posted Tuesday, July 3, 2012 7:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 3, 2012 5:32 AM
Points: 42, Visits: 126
I have a test "helpdesk" database, created by Spiceworks on which I would like to run some queries and import to Excel. I have set up an ODBC connection to Excel and I use Microsoft Query to connect to the database from Excel. I can read in whole tables without a problem, but when I try to run a filter (e.g. to show those tickets created after a certain date), it crashes and I get this message "Microsoft Query has stopped working". I'm on Windows 7, and I have tried the same thing on 2 PCs with the same result.
Post #1324389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse