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


--
madeqx
------------------------------------------------------------------------
madeqx's Profile: http://www.excelforum.com/member.php...o&userid=24247
View this thread: http://www.excelforum.com/showthread...hreadid=378961