1
Answer

Column name with dot in excel file

yokzu

yokzu

12y
3.9k
1
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 + "%')
Answers (1)