Question
December 19, 2007 at 07:05 AM
wright9999

How to link a MySQL table to Access and be able to see the time correctly

by wright9999 . Updated 18 years, 8 months ago

I have a MySQL server that is used for recording time for payroll. I use Access for our HR database. I would like to be able to link/import the MySQL timesheet table and create reports with Access but when I do the times always show up as dates in the linked/imported table. The timesheet database is set to capture times as TIME type (00:00:00).

Any suggestion as how to go about linking/importing would be great and would probaby make my life easier if the HR department could run more reports without my intervention, currently I write PHP pages for everything coming out of the timesheet database.

Thanks for you time.

This discussion is locked

All Comments