Excel \ Access Time issues

[Marcus]

Please can someone help me.

When I import data into an excel spreadsheet from MS
Access the date format corrupts to date format i.e
01/09/1900.

I cannot get time format back correct is there anyway of
converting time back to 24 hr clock within excel.

The Time format in Access is hh:mm:ss (I think) when i try
to convert this to excel it returns a date everytime.

Marcus

 

[Tom Ogilvy]

format the cell to

a time format.

 

[Calligra]

Try format(myAccesstime, hh:mm:ss)

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!