O
OPMCoordinator
Guest
OK, I give up.
I have just finished 4 hours searching and searching.
I have access to a MySQL database that has a time field. I wish to use the DTS packages in SQL Server 2000 to aquire the data to the SQL Server.
I can connect/see it using an ODBC connection, both with access 2k and the DTS bizzo on SQL server.
The time data is being seen by the microsoft end as a date format with way out values.
As MySQL has a very obvious different way of handling date/time (2 data types - one date and the other time), there must be an obvious solution to be able to use this data in access / SQL server.
Hiowever, I cant seem to find it.
damn - fire alarm must go - please help if you understand this - i will ammend later
mike
I have just finished 4 hours searching and searching.
I have access to a MySQL database that has a time field. I wish to use the DTS packages in SQL Server 2000 to aquire the data to the SQL Server.
I can connect/see it using an ODBC connection, both with access 2k and the DTS bizzo on SQL server.
The time data is being seen by the microsoft end as a date format with way out values.
As MySQL has a very obvious different way of handling date/time (2 data types - one date and the other time), there must be an obvious solution to be able to use this data in access / SQL server.
Hiowever, I cant seem to find it.
damn - fire alarm must go - please help if you understand this - i will ammend later
mike