DB2 Timestamp with MS Access 2000

R

Rene

Hi
I'm looking for a solution regarding the problem with the
DB2 timestamp format in MS Access. I have to access DB2
tables on an mainframe computer through ODBC (IBM
Version) and export the data into MS Access.

MS Access displays the timestamp information like this:
09.10.2003 21:38:26

What I need is the format of the original DB2 timestamp:
2003-10-09-17.28.49.223826

I have tried different stuff but I cannot bring the
timestamp in the format I need.

There must be people who had the same problem!

Regards
Rene
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Next Value from a DB2 System table 3
import data from db2 database to ms office access 2007 1
linking to DB2 tables (timestamp fields). 0
Linked servers 5
Using obdc with an IBM iSeries 2
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database 1
Importing MS Office Excel Comma Separated Values Files into a MSAccess 2003 database 1
DB2 Signon process for Ms Access Database 1

Top