Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 10th, 2003, 03:17 PM
Authorized User
 
Join Date: Aug 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Timestamp values and Access 2002

I am trying to import some tables from and oracle 8.17 server into access. It appears that access 2002 will not take in the timestamp values. In each record in the timestamp column it says "not an OLE object".
Here is my situation: I have to run some cross-database queries in an oracle database. However, due to legal/warranty issues, I am not permitted to create a DBLink in the server. Therefore, I figured I could use access to bring in those tables that live in different servers, run my query in access and export the results of that query to an excel spreadsheet, which is the final output I need.
I need to have that timestamp value, it is part of this query.
If there is nothing I can do about this Access/Timestamp issue, how can I get around this problem?
- Are there any other tools I could use to import those tables?
- Would a VB app tackle this problem?

Thanks.

Daniel Wajnberg
Analyst
Accenture

 
Old September 23rd, 2003, 05:14 PM
Authorized User
 
Join Date: Aug 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is anybody going to answer this?

 
Old September 23rd, 2003, 05:37 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Daniel

What sort of data would you expect to see in an Oracle timestamp field? And are you letting Access decide what datatype each field in the imported table should be, or have you gone down the import spec.\appending to existing table route?


Brian Skelton
Braxis Computer Services Ltd.
 
Old September 24th, 2003, 12:12 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

Have you tried linking Access to the Oracle database? You might be able to view the Oracle db as Access would and then import from there.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrading from Access 2002 to Access 2003 lryckman Access 1 July 16th, 2006 01:46 AM
DATE / TIMESTAMP default values WarHead MySQL 2 April 20th, 2006 10:18 AM
Access 2002 Chapter 5 JEHalm BOOK: Beginning Access VBA 0 January 11th, 2006 12:47 PM
Autonumber on Access 2002 pdunning Access 1 August 23rd, 2004 10:33 AM
Subreports in Access 2002 mhosneddine Access 1 October 26th, 2003 08:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.