Hello!

I have problems in importing my database from Access. In the field of date instead of |DD-MM-YYYY| I get |DD-MM-YYYY SEC-MIN-HR| format. This is not possible to import in the Links Database. for e.g.

|Date Time| Time=seconds-Minites-Hours
|25-8-1998 00-00-00|

How can I handle thins thing?

I beleive that if Implort.pl is integrated in the admin´.cgi would be the best. I prefer not to use Telnet at all. This is the only perl script which is not integrated in the web interface and actually this should be the first and constantly upgrading as an when more users join and bring suggestions/ problems.




------------------
rajani

Again, don't use Import.pl to import anything except Links 2.0 data. Use the editor.cgi for importing from Access.

Instead of having the program try and parse/recognize hundreds of different date formats, try and get the program to export it in a usable format.

In Access, give this a try:

1. In the Links table, go to Design.
2. For Add_Date and Mod_Date fields, just enter 'yyyy-mm-dd' in the display format. You may need to change the type to Text.

Hope that helps,

Alex