Hi, Is there a way to read an excel file with spaces in column names

sheenajenp over 8 years ago

Hi,

Is there a way to read an excel file with spaces in column names (ex: EMPLOYEE NAME) and write to a DB Table? It is known to me that spaces are not accepted in CDT, so is there any other way how I can read these columns with spaces and map it to be written on their respective columns on the DB Table?

Thanks!

Discussion posts and replies are publicly visible

Parents

0 Chris over 8 years ago

We utilize the macro method as well, to also get around excel's auto-formatting which has caused issues with columns not matching the CDT data type expected. The marcos write text-only data to a second, hidden sheet, then we ready from that in the parse excel node. Only issue has been occasional user training where they do not Enable Content in the excel file before saving/uploading.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 8 years ago

We utilize the macro method as well, to also get around excel's auto-formatting which has caused issues with columns not matching the CDT data type expected. The marcos write text-only data to a second, hidden sheet, then we ready from that in the parse excel node. Only issue has been occasional user training where they do not Enable Content in the excel file before saving/uploading.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data