Marco van der Linden
Member³
Steps to reproduce:
1. Create an Excel sheet with column headers which contain spaces (e.g. "Start Date")
2. Create table from spreadsheet definition (here you'll have to remove/replace the spaces in the column headers. In this case, replace the space by an underscore "start_date").
3. On the Data to Oracle tab, apply a SQL function to the column. (In the example above, I've set the column type to "string" and applied the SQL function "to_date(#, 'YYYY-MM-DD') ).
Now when you start to load PLD gives a insert error as the hash sign is replaced by the column header of the Excel sheet rather than the database column, so the insert statement becomes "to_date(Start Date, 'YYYY-MM-DDD')".
Of course there is the workaround of editing the Excel sheet and replace all the spaces by underscores, but still........
1. Create an Excel sheet with column headers which contain spaces (e.g. "Start Date")
2. Create table from spreadsheet definition (here you'll have to remove/replace the spaces in the column headers. In this case, replace the space by an underscore "start_date").
3. On the Data to Oracle tab, apply a SQL function to the column. (In the example above, I've set the column type to "string" and applied the SQL function "to_date(#, 'YYYY-MM-DD') ).
Now when you start to load PLD gives a insert error as the hash sign is replaced by the column header of the Excel sheet rather than the database column, so the insert statement becomes "to_date(Start Date, 'YYYY-MM-DDD')".
Of course there is the workaround of editing the Excel sheet and replace all the spaces by underscores, but still........
