Re: Access database to Oracle database???

hi ! Brian

I am having the same problems and i discovered the same way to do it. Only i am able to successfully link tables but the export does not seem to work.

The funny thing is that on using this export functionalitu access tells me that it has made tha table and so does the ODBC tool (i use this to look at databases and do general queries via odbc). But it has not really done that, since when i use SQL plus it says that the table does not exist. Same problem when i try to query on the table via this odbc tool. My guess was that the access function via odbc are not really tapping the error obtained from oracle (with respect to being unable to make the table) but then i may be wrong.

Any guesses as to what might be happening.

Another question is - Do you need to create the table apriori in oracle before you export the Access table data into it or does this export facility make the table also for you ?

Help much appreciated.

Jayesh

Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:3816FFF2.7C37908A_at_edcmail.cr.usgs.gov...
> You can define an ODBC connection to your Oracle Database. Then you can
> export an Access database to your Oracle database right from Access.
> Choose File|SaveAs,Export. Then choose To An External File Or Database.
> When given the Save As dialog box, choose the ODBC Databases from the
> File Type pulldown menu. You will then be prompted for the ODBC
> connection you want to use.
>
> HTH,
> Brian
>
>
> Sofie Kempeneer wrote:
> >
> > Howto??
> >
> > 10x
> > Sofie
> > Cereus.BE
> >
> > begin 666 Sofie Kempeneer.vcf
> > M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DME;7!E;F5E<CM3;V9I90T*
> > M1DXZ4V]F:64_at_2V5M<&5N965R#0I%34%)3#M04D5&.TE.5$523D54.E-O9FEE
> > M+DME;7!E;F5E<D!A9'9A;'9A<RYB90T*4D56.C$Y.3DQ,#(V5#$R-3 R,EH-
> > ,"D5.1#I60T%21 T*
> > `
> > end
Received on Wed Oct 27 1999 - 20:47:56 CDT