Problems loading TIME

[Daniel.Kuiper1@ing.nl]

I'm trying to load a unload from a DB2 database in to access database everything works fine only one thing doesn't.
There are time fields in the unload from DB2.
The hours minutes and seconds are separated by "." .
When importing this I can changes the time separator from ":" into "." but it still doesn't work.
When I changes the "." into ":" in the file everything works fine.
But this is no option for the file I eventually have to load because it is very big 230 MB.


Is there a way that does work to tell access that "." is the time separator.

Thanks

[RuralGuy]

Does it import the time field as a number or a string?

[Daniel.Kuiper1@ing.nl]

that was my solution if there was no fix for the problem described above.