Reading XLS Sheet Name with spaces in RPG2SQL
From Support
| If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
How do you do a SELECT statement on an XLS spreadsheet if there are spaces in the sheet name like Payroll Week 1?
[edit]
Solution:
You will need to place brackets [ ] around the sheet name. The sheet name must also have a dollar sign $ at the end of it:
SELECT * FROM [Payroll Week 1$]
