Why time format imported from dbf and excel is different?

[Herbert Chan]

Hi,

I import data from dbf and excel into access. With the data from dbf, the
time is shown as 00:00:00. However, the time from excel is 00:00:00 AM. When
I try to copy the data from the table imported from excel to the table
imported from dbf, access doesn't allow me.

I've checked and checked and have isolated the problem down to this
difference in time betweeen the two tables. I actually prefer the time to be
in 24-hour format.

How can I change the imported data to show the time in the format I want?
Because I will at the end export the table back into an excel spreadsheet.

Herbert

 

[Ronald W. Roberts]

Hi,

I import data from dbf and excel into access. With the data from dbf, the
time is shown as 00:00:00. However, the time from excel is 00:00:00 AM. When
I try to copy the data from the table imported from excel to the table
imported from dbf, access doesn't allow me.

I've checked and checked and have isolated the problem down to this
difference in time betweeen the two tables. I actually prefer the time to be
in 24-hour format.

How can I change the imported data to show the time in the format I want?
Because I will at the end export the table back into an excel spreadsheet.

Herbert

Use a query to see if you can format the time the way you want. If it
works, use an Append Query
to append the one table to the other.

Ron