Why time format imported from dbf and excel is different?

  • Thread starter Thread starter Herbert Chan
  • Start date Start date
H

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
 
Herbert said:
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
Click to expand...
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
 
Back
Top