Skip to Content
0
Former Member
Mar 10, 2009 at 02:22 PM

Import data from Excel

104 Views

Hi

I'm having real problems trying to read in data from an excel spreadsheet.

I created an ODBC system DSN pointing to my spreadsheet on the MII server, called myDSN.

I then created a new IDBC data server with the following settings

JDBCDriver : sun.jdbc.odbc.JdbcOdbcDriver

ServerURL : jdbc:odbc:myDSN

Username, password and validation query I've left blank.

When I try to use this server I get an error message "Cannot create a connection to the database".

Any ideas?