5 Replies Latest reply on Mar 20, 2012 4:37 PM by mythili.gopalakrishnan

    How to change a Sybase IQ connection to ODBC without losing all worksheet references?

    Michael Scharber

      Hi,

       

      I have a bunch of worksheets with references all over the place to a single data connection in my workbook - a Sybase IQ connection.  I would like to replace that connection with the same thing, but via ODBC.  I don't see a straightforward way to do this, without losing all my references and trying to work my way back with a new connection.

       

      Am I missing something?  It would be the same exact custom SQL (column order, names and types) feeding the source.

       

      Thanks,

       

      Michael