Have a table in Excel 2010 with a column formated as hour:minutes:seconds (00:00:00). First row is 00:00:00, second 00:00:01, and so it continues to 00:05:00.
Have a table in Access 2010 with a field formated as date/time, hh:nn:ss.
Copy column from Excel and paste into Access.
When doing some filtering in the table (right click in the first cell "is like 00:00:00", the query shows the result ok.
But when I try som other, i.e. 00:00:04, access won't return any result.
I have tried on several pc, and several versions. But I think Access or Excel must have a bug.
I can override the problem by choosing paste as special, and choose paste as text instead of paste as excel.
Someone help me?