Converting SQL server time to date and time

[frogman1001]

I extracted data from my server. It keeps a log of time like this
1069255091 (this morning)

I converted the data into access but now I need this cell value to b
the actual date and time.

Any one have the easy answer

 

[Rick Brandt]

I extracted data from my server. It keeps a log of time like this:
1069255091 (this morning)

I converted the data into access but now I need this cell value to be
the actual date and time.

Any one have the easy answer?

What kind of field is that? I have never had any problem pulling SQL
Server DateTime fields into Access and having them appear as anything other
than a proper DateTime value.