M
madeqx
I am trying to access an Oracle database through Excel. However,
Microsoft Query (which Excel uses) crashes before I can do anything
(Error:"String data, right truncated").
Creating a connection through MS Access works completly fine. Creating
a connection (i.e. no query, just connection) in Excel works fine as
well but is useless as I cannot perform any SQL queries on the
database. All in all, everything except Microsoft Query manages to
access the database. The question is then: are there any other ways
(i.e. not through Microsoft Query) of running SQL queries on the
database?
Thanks
Microsoft Query (which Excel uses) crashes before I can do anything
(Error:"String data, right truncated").
Creating a connection through MS Access works completly fine. Creating
a connection (i.e. no query, just connection) in Excel works fine as
well but is useless as I cannot perform any SQL queries on the
database. All in all, everything except Microsoft Query manages to
access the database. The question is then: are there any other ways
(i.e. not through Microsoft Query) of running SQL queries on the
database?
Thanks