not sure how to do this but my database is quite small so i did get it
handled by editing, thanks

my next qustions is eliminating the old data, or at least hiding it, what's
the best way to do this?




"Frank Kabel" wrote:

Hi
if your date values are in column A, enter this formula in B1 and copy down
for all rows. Now import column B in your database

--
Regards
Frank Kabel
Frankfurt, Germany
"hoeker" schrieb im Newsbeitrag
...
i am fighting the same issue and appreciate your continued help.

i do not know how to implement this solution, could you please expand your
directions?

thanks.
ross hoek

"Frank Kabel" wrote:

Hi
you may try using a helper column with the formula
=TEXT(A1,"[hh]:mm")


--
Regards
Frank Kabel
Frankfurt, Germany
"Jack Cutrone" <Jack schrieb im
Newsbeitrag ...
I am trying to import an excel spreadsheet with 12000+ records to access
but
can't stop a formatting problem for a time duration field. The data
appears
correctly in Excel cells as E.g. 00:17:33 but in the formula bar as
"12:17:33
AM" and the latter is what ends up in the Access database. I have
unlocked
the cell format protection, have reformatted the column using cell
format
to
[hh]:mm:ss or [mm]:ss and the format changes will appear in the data in
the
column but still appears in the formula bar as 12:17:33 AM. It is
apparent
that Excel is interpreting the entry as a time of day rather than a
duration.
How can I stop this? (As I mentioned there are over 12,000 records in
the
spreadsheet so PLEASE don't suggest anything that requires reentering
all
the
data :).]