4 Replies Latest reply on Nov 8, 2014 8:04 AM by Tom W

    0x80004005:syntax error in from clause

    dave john

      Hi,

      this might be basic question, I'm trying to connect to csv file which is in a share drive and used custom sql to change the path location to absolute (\\Networkdrivename\folderlocation\sales.csv)

       

      below is the custom sql

       

      SELECT [Sales#CSV].[Date] AS [Date],

        [Sales#CSV].[Region] AS [Region],

        [Sales#CSV].[Sales] AS [Sales]

      FROM \\Networkdrive\home\Tableau Source Docs\Fails\[Sales#CSV]

       

      and it throws me below error..please let me if I'm missing anything..

       

      Unable to open the text file. Please check that you have specified the correct field delimiter and that you have access privileges for the file.

      Microsoft JET database error 0x80004005: Syntax error in FROM clause.