Re: Copy the contents failure of 9 digit zip codes

Tech-Archive recommends: Fix windows errors by optimizing your registry

If we do that in the template version will that carry over to workbooks based
on that template?

BTW, thanks for the reponse.

"Ed Enstrom" wrote:

Formatting a column is for display. It does not change Excel's internal data type.

In the workbook, select the column, then go to Data - Text to Columns

In the wizard, define the data in the row as Text.

WhiskeyRomeo wrote:
I have a DTS package that copies contents from an Excel spread***. In the
spread*** all columns are formatted as "text." One column consists of Zip
codes. They are a mixture of 5 and 9 digit zip codes. The 9 digit zip code
has the hyphen in it (12345-6789). The zip code is copied to a table in a
SQL Server 2000 database and the particular column is defined as varchar(15).

The column in the database ends up being null for 9 digit zip codes. If we
remove the hyphen for 9 digit zip codes in the source Excel file, the 9
digits copy just fine.

This is occurring in Excel in Office 2003 as well as Office 2007.

Can anyone help me with this problem?


Bill

.

Quantcast