I have an Access database that links to an
Excel workbook to import the data. Recall the old saying "but it worked on
my machine" - ? Well, what can I say - it did work on my laptop, but not
on either of the customer's laptops on-hand. . .
My laptop =
IBM ThinkPad with Win XP Pro SP2, Office 2003 Pro SP2
Both customer laptops =
IBM ThinkPad with Win XP Pro SP2, Office 2003 Pro SP2
We even tried running the Access and Excel files directly off a thumb drive;
the same physical files that worked for me, did not work for the customer.
I inspected the linked worksheets, and found that cells that contained a number were coming thru to
Access as #Num on the customer machines. I re-formatted those cells as Text and
then re-typed those numbers, and then it worked.
From my vantage point, the only difference is that I always install everything for MS Office on my
PC's, but typically the customer's IT will select one of the typical installs.
I did notice that the Linked Table Manager was set for "install on first
use" so that might be related to the source of this problem.