Re: Access97 to Oracle/Sybase

If you are going to do this one time only, you should be able to export the data into a flat file. If you are using Sybase you can BCP the data into your tables. Try the following:

sp_help bcp

In article <3DT+wAAoiqS2IA+y_at_nisoft.demon.co.uk>,   Tim Shute <Tshute_at_nospamnisoft.co.uk> wrote:
> In article <36484437.136049C3_at_lmco.com>, CJ Jouhal <cj.jouhal_at_lmco.com>
> writes
> >Since Access97 is easier to use, a few people in my company
> >created databases in Access. Now wanting to have
> >the data available via intranet they want to have
> >the db accessible. I know and heard all the horror
> >stories of Access 97's performance issue regarding this.
> >
> >Bottom line:
> >Is there any way to export the databases from Access97
> >to an Oracle or Sybase (via odbc or something)
> >
> >Pardon my ignorance on exporting of databases in Access 97
> >but it would really make my life easier if I could.
> >
> >Also after exporting, will there be any problems or can
> >I just move it onto the appropriate server.
> >
> >Thanx in advance,
> Oracle 7.3.4 comes with an Access to Oracle migration wizard. Never
> tried it but who knows? It might just work!
>
> --
> Tim Shute
> Software Engineering Manager
>
> NiSoft (UK) Limited
> Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
> Internet: www.nisoft.co.uk
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 12 1998 - 00:00:00 CST