Thanks. We'll give that a try..
"Peter Jamieson" wrote:
You can try this
If you have a mixture of numbers and texts in a column but numbers in the
first 8 rows, you may need to get the OLE DB provider to "see" the column as
a text column. However, selecting the column and using Format|Cells to set
the format as Text does not appear to be enough. One way that does appear to
work is
- select the column
- select the Data|Text to Columns... menu option
- click Next through the wizard until you reach Step 3 of 3, then select
Text as the Column Data Format.
or perhaps the "DDE" approach described at the top of
http://tips.pjmsn.me.uk/t0003.htm
Peter Jamieosn
"