Skip to Content
avatar image
Former Member

Exception: DBD, [Microsoft][ODBC Excel Driver] Syntax error in FROM clause.

Dear experts,

I'm trying to create an universe linked to an Excel File.

I've created the ODBc connection and the DNS Data Source and inserted the table (table name RAC$) in the Universe. however, when I try to map each table field in the universe's Objects I'm getting this error message:

"Exception: DBD, [ODBC Excel Driver] Syntax error in FROM clause.State:37000".

I've tried to rename the table, inserting square brackects and also add new parameters to the universe («Transactional Available = "Yes"» and «Delimited Identifier = "Yes"») but still no solution to my problem.

Any advice, tip or trick? 😊

Thank you. My best regards.

Inês Santos

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 09, 2010 at 12:26 AM

    Hi Ines,

    It may have a problem with the $ symbol. Is there a way you can manually remove that in the table name in the universe? Or possibly in the objects? I have not built a universe on Excel before, but I did read something about using named ranges and that may help.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2010 at 12:29 AM

    Dear Experts,

    I found what mt problem was: when creating the universe I was defining the source as "generic > ODBC" instead of "Microsoft > Excel Spreadsheet". After changing this, the FROM clause was no longer an issue and the problem was solved.

    Thank you for your time.

    Inê

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rachel,

      I believe this has nothing to do with BO version.

      You were creating your ODBC Data Source via Windows Control Panel? In the System DSN when you click "add" you should have Excel Driver Available. Then, when you go to universe designer, click "create a new universe" and when you choose "new connection" there should be the option "Microsoft - Excel Spreadsheet"....

      Sorry I can't help you further.

      My best regards,

      Inê

  • avatar image
    Former Member
    Jun 11, 2010 at 03:16 PM

    😊 Circunflex, yes... It's ok, I'm used to it.

    Thank you for your post!

    Inê

    Add comment
    10|10000 characters needed characters exceeded