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

    0x80004005:syntax error in from clause

    dave john


      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.