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.