Import Excel Stikeout Format Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import an Excel worksheet that contains strikeouts, but Access
seems to ingore all formating. Does anyone know how this can be done or a
recommended workaround? Thanks in advance.
 
Two problems:
1. Access does not preserve Excel formatting when importing
2. There is no equivilant format in Excel to StrikeOut.
 
There's no easy way. As Klatuu says, Access text fields don't do text
formatting.

If the strike-through format is applied to entire cells, the simplest
work-round would be to add a column to the worksheet and put values in
each cell in this column to indicate whether or not the corresponding
cell in the other column is struck through or not.

If the format is applied to characters in cells that contain text, you'd
need to write code that extracted the formatted text from each cell (the
only way I know of doing this is to copy to the clipboard) and then put
the corresponding RTF or HTML string into an Access memo field (with a
rich text control to display it).
 
Back
Top