Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Converting column names with spaces to underscores (Read 5444 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Converting column names with spaces to underscores
20.12.09 at 22:46:08
 
Converting column names with spaces to underscores

 
The new table dialog and the multiple rows insert dialog of the SQL*XL software were improved. In these dialogs a common error is that column names are given with spaces where the database does not allow that. SQL*XL detects this and offers to convert spaces in column names to underscores. If the database does permit spaces in the names no conversion is done but the column name is wrapped in square brackets.
Back to top
 
« Last Edit: 20.12.09 at 22:46:37 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1