"[Microsoft][ODBC Excel Driver] 'Sheet1$' is not a valid name. "
posted 3 years ago
This is my code:
I'm getting the error as : [Microsoft][ODBC Excel Driver] 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
I have saved the file as Sheet1.xls . "mede" is my data source name which links to this workbook : C:\ETL\Sheet1.xls
Can someone please help me out and tell me what changes i should make to the query !
Pardon me for the extremely late reply, nonetheless, I suggest using java.sql.DatabaseMetaData to interrogate the data source you are connecting to in order to find the table names.
I leave you to peruse the javadoc for DatabaseMetaData.