{"id":2340,"date":"2022-08-30T15:24:03","date_gmt":"2022-08-30T15:24:03","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/01\/05\/problem-about-ms-query-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:24:03","modified_gmt":"2022-08-30T15:24:03","slug":"problem-about-ms-query-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/problem-about-ms-query-collection-of-common-programming-errors\/","title":{"rendered":"problem about ms-query-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li>\n<img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/0f847527031d81b6f4834ce1cef5322a?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nSean Cheshire<br \/>\nmysql excel connection ms-query<br \/>\nI need to import some data to Excel from MySQL DB via MS Query (using MySQL ODBC driver). At the first step I set up Data Source name, TCP\/IP server, port, username, password and schema name. When I pressed the Test button, the connection worked fine. Next, I selected the table name, needed columns, filters, sort order and get to the Query Wizard &#8211; Finish screen. Regardless of choosing Return data to Excel or View data in MS Query, after pressing the Finish button, I get an MS Query crash.I&#8217;m gi<\/li>\n<\/ul>\n<p id=\"rop\"><small>Originally posted 2014-01-05 21:54:31. <\/small><\/p>","protected":false},"excerpt":{"rendered":"<p>Sean Cheshire mysql excel connection ms-query I need to import some data to Excel from MySQL DB via MS Query (using MySQL ODBC driver). At the first step I set up Data Source name, TCP\/IP server, port, username, password and schema name. When I pressed the Test button, the connection worked fine. Next, I selected [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2340","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=2340"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2340\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}