yokzu

yokzu

  • NA
  • 306
  • 0

Column name with dot in excel file

Oct 2 2012 7:16 AM
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)