Loading

Column name with dot in excel file

yokzu

Hi,
I want to query in an excel file but first headlines has dot. So column names with dots and I couldnt get search anything, it is getting erro. How may use these column names in sql query?

SELECT * FROM [Sheet1$A:W] WHERE ([Sheet1$].[column.1] LIKE '%" + textBox1.Text + "%')

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

NitRiX Reloaded14y ago
Typically you will not be able to retrieve column names with . from an excel sheet using OLEDB or ODBC. Because it is not a valid or recognizable syntax.

Under score is a valid syntax. But '.' typically we use it to distinguish between two [schema].[table].[column] like that.

Suggest renaming the excel columns.