cell date format problem

's Computer Specifications

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.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
losing date format when referencing date cell on another sheet and	Rich	Microsoft Excel Programming	3	9th Dec 2009 01:14 AM
date format cell, to text format	sunilpatel	Microsoft Excel Programming	2	31st Aug 2009 03:55 PM
How can I get date of file creation to XLS cell in date format?	=?Utf-8?B?UmFkZWsgU2ltZWs=?=	Microsoft Excel Worksheet Functions	3	8th Nov 2007 04:24 PM
cell format for date/time in same cell excel 2003	=?Utf-8?B?U2FuZHk=?=	Microsoft Excel Worksheet Functions	1	18th Jan 2006 03:46 AM
problem with formatting cell to date format	=?Utf-8?B?RGVs?=	Microsoft Excel Worksheet Functions	7	8th Dec 2004 05:14 PM