Re: Copy the contents failure of 9 digit zip codes

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

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