on 06-08-2010 12:07 PM
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
Circunflex, yes... It's ok, I'm used to it.
Thank you for your post!
Inê
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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ê
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ines,
Thanks for sharing how you resolved this! I will bookmark this so that I can find it when I will likely need it!
Bill
Sorry I don't know how to make the accent circumflex! Or is that what you call it? On top of the e?
Edited by: wavery on Jun 11, 2010 12:07 AM
Edited by: wavery on Jun 11, 2010 12:09 AM
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ê
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.