First of all, Hi
everyone. I have been away for a bit. New job and
all.
I have an excel
spreadsheet from a client of mine which contains a customer list. One of
the fields is a zip code field, which contains both 5digit and Zip+4
codes. When I set up a DSN to query the spreadsheet, everything works
fine, but the zip code field appears to be coming back as a "number" field
rather than a text string. I have jacked with the settings in the DSN to
no avail.
I do not need to
keep this going, I just need to be able to write a query to parse the
spreadsheet, apply some logic and then insert all the data into a
database. One time use.
Got any
ideas?
John Woods
MediaWrx
