2 Replies Latest reply on Feb 27, 2013 11:39 AM by Matthew Lynch

    Import Access query into Tableau?

    Matthew Lynch

      Hi Everyone,

       

      When attempting to connect to a data source in Tableau, my Access 2010 query does not appear as a possible connection. I tried deleting and recreating it, and this didn't make a difference.

       

      Also, I've tried copying the SQL query that I made in Access into the 'Custom SQL' section of the import dialogue box in an attempt to just run the query in Tableau, and I got this error:

       

      Database error 0x80040E14: Syntax error in FROM clause.

       

      Unable to connect to the Microsoft Excel file "C:\Users\Matthew\Documents\FAST\SSI Research\SSI 2014\Market Data\SSI Relational Database.accdb". Check that you have access privileges for the requested file and that it is not open in another application.

       

      I followed the recommendations of the message and it didn't make a difference.

       

      Sorry guys if this is ridiculous question, I'm no database wiz. Thanks in advance for your help.

       

      -Matthew