Transfer Spreadsheet (different question)

[J. Adams]

Hi,

I use the transfer spreadsheet method to import data into
Access 2002. Before I import the spreadsheet I run a
macro on the spreadsheet to trim the string values. One
problem I have run across is sometimes I get a cell that,
when the user was filling it out, they must of just held
their finger, thumb, elbow or whatever on the spacebar.
So when you press F2 in that cell you can tell there is
nothing in there but 255 spaces because you don't even
see the cursor. The macro I run deletes crap like that
and I've tested the cell afterword and there is no longer
anything in it, like it should be. The problem I am
having is when I use TransferSpreadsheet to bring in the
data the record where that 255 space thing occured
doesn't get imported. Like I said, it looks fine in Excel
after I run the macro so I am assuming that there is
still something in there that the TransferSpreadsheet
method doesn't like so it craps out on the record. Can
anybody tell me what is happening here and how I can fix
this problem?

Thanking you in advance..