That is the way the Excel ISAM driver was designed to work. It adds the apostrophe to discriminate
between text and numeric values. I don't believe it shows up in the cell, just the formula bar.

Paul
~~~~
Microsoft MVP (Visual Basic)
Back to top
Sam Jost
Posted: Tue Jun 28, 2005 8:43 am
Guest
My bad - is there any way to get rid of this 'Feature by design' so I
don't have these apostrophs in every cell?
Maybe using a different type instead of NVARCHAR for the field,
anything?