Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert TimeStamp field from Oracle to Access 2002

Status
Not open for further replies.
rejome

rejome

Programmer
May 9, 2002
17
CA
Hi guys (and girls too ;)

I'm trying to convert a DB from Oracle to Access. Easy. But, I got a 'Multiple-step OLE DB operation' error when I try to convert an Oracle TimeStamp field to an Access Date/Time field. Well, not for all records. The error appends only when my Oracle field contains 0001-01-01 as date. And no, it's not supposed to be year 2001!

Please help me, I've read enough on Access for this year!
 
Status
Not open for further replies.

Similar threads

hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
428
hermanlaksko
hermanlaksko
breezett93
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
1K
dhookom
dhookom
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
3K
lameid
lameid
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
756
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top