I have a DTS package that copies contents from an Excel spreadsheet. In the
spreadsheet 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

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:

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:

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:

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:

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:

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:

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:

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:

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: