Importing excel file

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Importing data from excel can be tricky to say the least, but can anyone
explain why an empty cell can cause the import to fail. I have narrowed
down import failure to a single cell, and that cell is empty. If I press
delete on the empty cell the import goes ahead. When I return the cell back
to its original state of being empty the import again does not work. What
the h... is going on here? Anybody any idea?

Pat
 
Define empty: Null, 0, deleted, empty string... They are not the same.
I am guessing the cell is not really empty (Null)
 
empty defined: no string, no null, no zero(0), in other words a clear cell
and a clear formula bar.

Pat

6 into 32 not yet, but maybe!!
 
Back
Top