Help with coding please. Newbie.

On Wed, 5 Jul 2006 05:09:07 -0500, kirkm wrote:

> Thank you PL. That worked perfectly.
> Can I ask another question please?
>
> When I link to the spreadsheet from Access, many cells show as
> as #Num!
> Is there some way in Excel to make every cell display ok in Access?
> (All of them are or can be text).
[...]

AFAIR #Num values in Access means that you have non-numerical content in
Excel. Try to multiply all the values by 1 (maybe in separate column, that
will be imported/linked to Access except the current one). Or, if you have
some txt values (I mean, values containing characters other than digits
and/or decimal dot), build a numerical column with formula (using, for
example, the "ISNUMBER" excel function to distinguish)

--
PL

On Wed, 5 Jul 2006 12:42:58 +0100, Piotr Lipski wrote:

> On Wed, 5 Jul 2006 05:09:07 -0500, kirkm wrote:
>
>> Thank you PL. That worked perfectly.
>> Can I ask another question please?
>>
>> When I link to the spreadsheet from Access, many cells show as
>> as #Num!
>> Is there some way in Excel to make every cell display ok in Access?
>> (All of them are or can be text).
> [...]
>
> AFAIR #Num values in Access means that you have non-numerical content in
> Excel. Try to multiply all the values by 1 (maybe in separate column, that
> will be imported/linked to Access except the current one). Or, if you have
> some txt values (I mean, values containing characters other than digits
> and/or decimal dot), build a numerical column with formula (using, for
> example, the "ISNUMBER" excel function to distinguish)

PS: you also can link/import all the xls data as text, just concatenate (in
a separate column) an empty string at the beginning of every value, and
import this column instead of the current one.

--
PL