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$]

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016