#1 (permalink)  
Old 07-16-2008, 07:45 AM
Registered User
 
Join Date: Jul 2007
Posts: 126
smyhte is on a distinguished road
Default adding excel links

just a quick question. in the idx_link table the date field is in the format datetime. how do you add the same format using excel? the only way i can import the correct date is to use date format of the type 0000-00-00. if i use custom option in excel in the format dd/mm/yyyy hh:mm then quite rightly, it dosen't import. if i add link via admin panel then it adds datetime correctly. is there a way to add link with correct date & time via excel? manyn thanks.
__________________
I know more today than i did yesterday...
V5.3.0
Reply With Quote
  #2 (permalink)  
Old 07-16-2008, 09:12 AM
Registered User
 
Join Date: Jul 2007
Posts: 126
smyhte is on a distinguished road
Default

sorted it. thanks anyway. cheers
__________________
I know more today than i did yesterday...
V5.3.0
Reply With Quote
Reply

Thread Tools
Display Modes

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 On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding links error marian v5.x 7 03-04-2008 05:34 PM
Importing Excel output with phpmyadmin ? Frank71 Website Development 9 05-31-2006 10:43 PM
Adding Catgories and Links craven v5.x 1 03-11-2004 05:58 PM
adding links in admin morgankd v5.x 1 02-24-2004 05:22 PM
Adding no http:// links Che Guevara v5.x 7 04-26-2002 01:18 AM

HACKER SAFE certified sites prevent over 99.9% of hacker crime.

All times are GMT -5. The time now is 03:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO
SSL Certificate