cell date format problem
 

it cause an apostrophe is being written in there, I'm use
Provider=Microsoft.Jet.OLEDB.4.0 and ado to insert date, other columns are
fine except the format column. Pleaes help.

wrote in message
...
hi, I have excel cell to use "dd/mm/yy" foramt and cause ado code insert a
"'" in front of the date string? how to avoid that? Please help.

cell date format problem
 

hi, I have excel cell to use "dd/mm/yy" foramt and cause ado code insert a
"'" in front of the date string? how to avoid that? Please help.