{"id":2021,"date":"2013-03-27T11:00:04","date_gmt":"2013-03-27T11:00:04","guid":{"rendered":"http:\/\/www.mjtnet.com\/blog\/?p=2021"},"modified":"2013-03-27T11:00:04","modified_gmt":"2013-03-27T11:00:04","slug":"getting-data-from-excel-without-office-installed","status":"publish","type":"post","link":"https:\/\/www.mjtnet.com\/blog\/2013\/03\/27\/getting-data-from-excel-without-office-installed\/","title":{"rendered":"Getting Data From Excel Without Office Installed"},"content":{"rendered":"<p>In <a href=\"http:\/\/www.mjtnet.com\/blog\/2008\/04\/16\/retrieve-entire-excel-sheet-using-dbquery\/\">this post from 2008<\/a> I demonstrated how to get data from Excel worksheets using Macro Scheduler&#8217;s database functions.<\/p>\n<p>This works fine if Office is already installed on the PC. \u00a0 But what if you want to get data from an Excel sheet and the PC you are running on doesn&#8217;t have Office installed?<\/p>\n<p>Well you need the Office Data Connectivity Components which you can download from microsoft.com here:<\/p>\n<p><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=23734\">http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=23734<\/a><\/p>\n<p>This will install the OLEDB\/ODBC drivers which <a href=\"http:\/\/www.mjtnet.com\/manual\/index.html?dbconnect.htm\">DBConnect<\/a> can then use to make a connection to a workbook. \u00a0You can then use <a href=\"http:\/\/www.mjtnet.com\/manual\/index.html?dbquery.htm\">DBQuery<\/a> to retrieve data from a sheet <a href=\"http:\/\/www.mjtnet.com\/blog\/2008\/04\/16\/retrieve-entire-excel-sheet-using-dbquery\/\">as shown previously<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post from 2008 I demonstrated how to get data from Excel worksheets using Macro Scheduler&#8217;s database functions. This works fine if Office is already installed on the PC. \u00a0 But what if you want to get data from an Excel sheet and the PC you are running on doesn&#8217;t have Office installed? Well [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,6],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts\/2021"}],"collection":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/comments?post=2021"}],"version-history":[{"count":1,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts\/2021\/revisions"}],"predecessor-version":[{"id":2022,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts\/2021\/revisions\/2022"}],"wp:attachment":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/media?parent=2021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/categories?post=2021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/tags?post=2021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}