"HX" <mymail@somemail.com> wrote in message
news:edvvzpucHHA.4872@TK2MSFTNGP03.phx.gbl...
>I have to import a particular spreadsheet monthly (sql 2000, using
>enterprise manager). The key field can have a value like 89976, which
>appears to be just a number, though it is not calculated, OR it can have a
>value like 5X6D4.
>
> I have tried importing to a new table, importing to an existing table,
> saving the key column as text in Excel (for good measure), and setting the
> import of that field to any variety of field types. But I just can't seem
> to get ALL the values to import! I either get all the number-looking
> values (89976) and the values that were letter/number mixed (5X6D4) import
> as NULL or vice versa!
>
> How can I get ALL the values to import correctly?
>

"TheSQLGuru" <kgboles@earthlink.net> wrote in message
news:uwDdaaLdHHA.4684@TK2MSFTNGP06.phx.gbl...
> How are you doing the import?
>
> Have you selected all of the key cells in excel and formatting as Text?
>
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
>
> "HX" <mymail@somemail.com> wrote in message
> news:edvvzpucHHA.4872@TK2MSFTNGP03.phx.gbl...
>>I have to import a particular spreadsheet monthly (sql 2000, using
>>enterprise manager). The key field can have a value like 89976, which
>>appears to be just a number, though it is not calculated, OR it can have a
>>value like 5X6D4.
>>
>> I have tried importing to a new table, importing to an existing table,
>> saving the key column as text in Excel (for good measure), and setting
>> the import of that field to any variety of field types. But I just can't
>> seem to get ALL the values to import! I either get all the
>> number-looking values (89976) and the values that were letter/number
>> mixed (5X6D4) import as NULL or vice versa!
>>
>> How can I get ALL the values to import correctly?
>>
>
>

"HX" <mymail@somemail.com> wrote in message
news:eTxWRAXdHHA.1220@TK2MSFTNGP03.phx.gbl...
> Yes, I have selected all the cells and formatted them as text (for the
> key).
>
> Then I am using Enterprise Manager's Import function to import from Excel
> to SQL 2000.
>
> "TheSQLGuru" <kgboles@earthlink.net> wrote in message
> news:uwDdaaLdHHA.4684@TK2MSFTNGP06.phx.gbl...
>> How are you doing the import?
>>
>> Have you selected all of the key cells in excel and formatting as Text?
>>
>> --
>> TheSQLGuru
>> President
>> Indicium Resources, Inc.
>>
>> "HX" <mymail@somemail.com> wrote in message
>> news:edvvzpucHHA.4872@TK2MSFTNGP03.phx.gbl...
>>>I have to import a particular spreadsheet monthly (sql 2000, using
>>>enterprise manager). The key field can have a value like 89976, which
>>>appears to be just a number, though it is not calculated, OR it can have
>>>a value like 5X6D4.
>>>
>>> I have tried importing to a new table, importing to an existing table,
>>> saving the key column as text in Excel (for good measure), and setting
>>> the import of that field to any variety of field types. But I just
>>> can't seem to get ALL the values to import! I either get all the
>>> number-looking values (89976) and the values that were letter/number
>>> mixed (5X6D4) import as NULL or vice versa!
>>>
>>> How can I get ALL the values to import correctly?
>>>
>>
>>
>
>