PC Review


Reply
Thread Tools Rate Thread

cell date format problem

 
 
Guest
Posts: n/a
 
      13th Mar 2007
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.
>
>



 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
 
      13th Mar 2007
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.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:08 PM.