Can I import table from oracle to MS access by Transfertext?

S

snatt

Can I import table from oracle to MS access by
Transfertext?
I have to make back up of Oracle table.. make by using
MSaccess coding..and by ODBC..
Please help me...
 
V

Van T. Dinh

(I am not an Oracle expert) but surely Oracle has much more sophisticates
back-up and restore procedures than what you proposed???
 
S

snatt

I have to use access.. running access and then make oracle
table back up in a Mdb. Can I?
My application now using MSaccess .. but use Oracle
database. And I have to make back up of oracle table with
running MSaccess, can you help me?
Thank you.
 
J

Joe Fallon

Yes you can.
You start by linking to the Oracle tables in Access.
Then you write MakeTable queries to "move" the data from Oracle to local
Access tables.
 
G

Guest

Thank you Joe.
Now I did.
-----Original Message-----
Yes you can.
You start by linking to the Oracle tables in Access.
Then you write MakeTable queries to "move" the data from Oracle to local
Access tables.
--
Joe Fallon
Access MVP






.
Click to expand...
 

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

Can't get real oracle error with Access error 3155 0
Linking Access and Oracle Database 2
Import NCLOB field from Oracle to MS Access 2003 2
Access 2007 ODBC for Oracle linked table issue 0
Error: Cannot add MS ODBC for Oracle 1
Get Data From Oracle DB Into Access?? 1
problem in exporting table from MSAccess to Oracle.... 3
Need help with Access 97 and Oracle 9i 6

Top