happykappy
Technical User
I imported excel times into access but some times did not show up at all. For example from 8:00 AM to 12:45 PM all imported into a blank table in access. However the afternoon times did not imnport at all. I had these grouped by rooms, 1 - 5 and each room had the same problem. The morning times from 8 to 12:45 came across great but the afternoon left blank records.
I tried changing the format in excel to other time options, but some did not import at all. I imported into a blank database. Emptied all the records in that database, changed the time format to text and tried again. Again, the AM imported but no PM. The time format in excel changed to date/time during the import.
Any suggestions on this problem.
I tried changing the format in excel to other time options, but some did not import at all. I imported into a blank database. Emptied all the records in that database, changed the time format to text and tried again. Again, the AM imported but no PM. The time format in excel changed to date/time during the import.
Any suggestions on this problem.