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