Q0154 - I am trying to use the ODBC connection with a Microsoft Excel spreadsheet, but it is asking for a table name. What do I do?
I am trying to use the ODBC connection with a Microsoft Excel spreadsheet, but it is asking for a table name. What do I do?


The ODBC connection is asking for the defined area within your spreadsheet that should be used. In Excel, select the data rows and columns and create a named rangeEdit/Define/Name. This appears as a table name in the Database Connection Wizard


Related Topics