Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 25, 2005 at 11:01 am in reply to: Date formats / other questions #17085
    lolacherrycola
    Member

    Hi again

    Just to let you know, I set the field type from 'date' to 'text' in access / did an odbc import and now this seems to work……..the date is being seen as '01/01/2005' in MySQL – I will try setting this field back to 'date' format in Mysql to see what happens………..

    I am really on my way now….thanks again both of you.

    February 25, 2005 at 10:10 am in reply to: Date formats / other questions #17084
    lolacherrycola
    Member

    Thanks so much Peter. I wouldn't have known where to start trying to solve this!

    I've done what you said and it's worked – I managed to import a table into Mysql via ODBC…..the only slight problem is that the data in the fields ( in Mysql) looks like e.g. '2005' instead of '01/01/2005' – it's created a 'varchar' 4 length datatype for this ( when the field type in Access is 'Datetime' ) – but I will play around to see if I can solve this………….

    You have both been such a help – thank you

    February 25, 2005 at 1:04 am in reply to: Date formats / other questions #17082
    lolacherrycola
    Member

    Thanks to both of you for helping me out ….I see you have been successful (with the dates/ODBC). I wonder what's wrong…better check all my documentation in MySql.

    I'm using MySQL 4.1.9 and the Mysql ODBC driver is version 3.51.11.00. It's also Access 2000.

    I wanted to set up a calender in Excel starting e.g. 01/01/05 for all 365 days of the year. I then wanted to import this CSV into a Mysql table via SQL Log (which works) and then view this table in Access – but I'm seeing squares in Access in the date field instead of a text date like 01/01/05.

    I'll check that thread out Peter thanks.

    Sorry I'll try to explain this as clearly as I can!

    I've tried setting the date field in Mysql table to different data types ( e.g. 'date' or 'txt' ) and then imported the CSV file into this field but ithe date field still looking like squares in Access over the Mysql ODBC connection!

    I set the datatype to 'date' the Mysql table and after the CSV was imported the date comes out like '2005-10-05' using Sql Yog ( when what I really want is in the field '05/10/05' – so to achieve '05/10/05' I have used a 'text' data type instead of the 'date' type which works ).

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)