ok, running problem pulling zip code csv file using ado. whats happening if first set of zip codes 5 digits long, datatype assigned integer whole field property in recordset wouldn't problem if following zip codes weren't 9 digit zip code dash (99999 vs 99999-9999). when these 9 digit zip codes encountered, field yields null. so, can assumet jet 4 takes small sample of data (first 3 records?) , assigns datatype field. ive tried setting field type during runtime, failed either because don't know doing or beyond control.
a couple of note worthies: 1. have control of sql statement pulls info (which uses group clause) 2. have limited control before data pulled in. 3. runtime language vb6 using ado.
any suggestions or pointers?
yes, ado type coercion based on first record. dash '-' invalid character in integer type, won't parse them. want entire thing string (really, do- zip codes strings, not integers).
it might worth preparse data. write small program read csv , add -0000 5-digit records. records 10 digits, -, , should coerced string.
Comments
Post a Comment