[This topic is migrated from our old forums. The original author name has been removed]
I work a lot with numeric codes that need to be treated as strings (ie. leading or trailing zeroes are significant). When I export these types of columns I specify that text fields are quoted so that it's obvious that these types of columns are strings, not numbers.
When I choose to import them using DbVisualizer, though, the "Import CSV" function still interprets them as numbers by default. I have to remember to change the field type in the "Data" grid to ensure that they get imported properly. Could the import function be changed to treat any input column surrounded by the character indicated in the "Text Quoted Between:" option as a String field, regardless of what the data looks like?
Thanks.
anonymous