At 02:24 PM 10/25/2007, Richard Wesley wrote:

>The real problem is that Excel is not a database and the typing is
>inferred by the JET engine. And if JET sees a column of all [0-9]*(\.
>[0-9])*, it is going to type it as a real. The only way to get it to
>do anything different might be for the user to have a zip+4 table
>with dashes in it.

Ah, I didn't realize the situation you were in. Perhaps you can tell the
Excel users to change the column format for the zipcode fields to be Text
before importing? Should import correctly then. Anyway, my sympathies.

BTW, Tableau rocks!