Bug #178
Properly handle special characters and invalid data types in Upload Worksheet function
90%
Description
Text fields containing the character ' in uploaded worksheets cause no data to be loaded. Also this happens when numeric fields such as Priority or Unit Cost contain text. Upload must be improved to automatically handle these problems where possible. (Note: Error message code has already been added to detect these cases, but cdde not implemented to correct them.)
History
#1 Updated by Jeff Mack over 11 years ago
- Status changed from New to Assigned
- Assignee set to Jeff Mack
Replaced single quote in text fields on upload with two single quotes. Recognized in ACcess and Oracle table as single quote.
#2 Updated by Jeff Mack over 11 years ago
- Estimated time set to 32.00 h
#3 Updated by Jeff Mack about 11 years ago
Jeff Mack wrote:
Text fields containing the character ' in uploaded worksheets cause no data to be loaded. Also this happens when numeric fields such as Priority or Unit Cost contain text. Upload must be improved to automatically handle these problems where possible. (Note: Error message code has already been added to detect these cases, but code not implemented to correct them.)
#4 Updated by Jeff Mack about 11 years ago
- Priority changed from Normal to Low
- % Done changed from 0 to 90
' character was not handled properly in SQL Insert to Miser. This is now fixed.
#5 Updated by Jeff Mack about 11 years ago
ALl special characters are handled ok. However, the error message returned when number fields contain text, e.g. is unclear:
No value given for one or more required parameters. (Microsoft JET Database Engine)