5 Replies Latest reply on Apr 10, 2013 11:01 AM by Cristian Vasile

    Features and limitations of the MS Jet Driver while connecting to local files

    davidclaen

      Hi Community,

       

      does somebody know a good reference of features/syntax that MS Jet Driver supports while connection to loacl files (Excel, CSV, ...)?

      I already found this http://office.microsoft.com/en-us/support/results.aspx?ctags=CH010072899 but I'm not sure, if this is the right reference for sql syntax to work with.

       

      I tried around a little bit and it seems to me that there is a limitation of characters in the Tableaus Custom SQL or the Jet Driver. Is this right?

       

      Do you know further limitations, pros and cons of using MS Jet Driver?