Problem:
When there are spaces in an XLS spreadsheet name (for example: Payroll Week 1), how do you write a SELECT statement for this spreadsheet?
Solution:
Put the spreadsheet name in brackets [ ] and type a dollar sign $ at the end of the spreadsheet name.
For example:
SELECT * FROM [Payroll Week 1$]
Last Modified On:
No, open a new Support Case