|
 |
asptoday_discuss thread: transfering data
Message #1 by "khan deepu" <khandeepu@h...> on Wed, 29 Aug 2001 20:53:56 +0000
|
|
hi,
i have some data's in ms access.i want it to migrate it to oracle
database.is their a way to do it.please help me.
Message #2 by Sankalp Gaggar <SankalpG@I...> on Thu, 30 Aug 2001 10:06:09 +0530
|
|
you can use DTS -data tranformation services to accompish this.
-----Original Message-----
From: khan deepu [mailto:khandeepu@h...]
Sent: Thursday, August 30, 2001 2:24 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] transfering data
hi,
i have some data's in ms access.i want it to migrate it to oracle
database.is their a way to do it.please help me.
Message #3 by "Frank J Hill" <frank@i...> on Thu, 30 Aug 2001 10:23:47 +0100
|
|
Hi Khan,
You can either use an Export routine to send the data to oracle or you can
open Oracle and import the data from Access.
Whichever way you choose you will need to identify an ODBC connection which
will make the data type conversions required.
If you export from Access use - File - Save as/Export >>>>> and then use a
.csv file or select an appropriate ODBC driver for the database it is going
to.
The data you are exporting will need to fit the rules applicable to the
database you are sending it to - as an example: No spaces in field names
etc...
Good luck.
Frank Hill - Director
Ion Software Ltd.,
90 Duke Street,
Barrow in Furness,
Cumbria. LA14 1RD
Tel: 01229 812713
Fax: 01229 823403
----- Original Message -----
From: "khan deepu" <khandeepu@h...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Wednesday, August 29, 2001 9:53 PM
Subject: [asptoday_discuss] transfering data
> hi,
> i have some data's in ms access.i want it to migrate it to oracle
> database.is their a way to do it.please help me.
Message #4 by "khan deepu" <khandeepu@h...> on Thu, 30 Aug 2001 14:17:23 +0000
|
|
sir,
please provide with the detail info about exporting data,and how to
set dns.
cheers
>From: "Frank J Hill" <frank@i...>
>Reply-To: "ASPToday Discuss" <asptoday_discuss@p...>
>To: "ASPToday Discuss" <asptoday_discuss@p...>
>Subject: [asptoday_discuss] Re: transfering data
>Date: Thu, 30 Aug 2001 10:23:47 +0100
>
>Hi Khan,
>You can either use an Export routine to send the data to oracle or you can
>open Oracle and import the data from Access.
>Whichever way you choose you will need to identify an ODBC connection which
>will make the data type conversions required.
>If you export from Access use - File - Save as/Export >>>>> and then use a
>.csv file or select an appropriate ODBC driver for the database it is going
>to.
>The data you are exporting will need to fit the rules applicable to the
>database you are sending it to - as an example: No spaces in field names
>etc...
>Good luck.
>
>Frank Hill - Director
>Ion Software Ltd.,
>90 Duke Street,
>Barrow in Furness,
>Cumbria. LA14 1RD
>Tel: 01229 812713
>Fax: 01229 823403
>----- Original Message -----
>From: "khan deepu" <khandeepu@h...>
>To: "ASPToday Discuss" <asptoday_discuss@p...>
>Sent: Wednesday, August 29, 2001 9:53 PM
>Subject: [asptoday_discuss] transfering data
>
>
> > hi,
> > i have some data's in ms access.i want it to migrate it to oracle
> > database.is their a way to do it.please help me.
Message #5 by hkchang@h... on Fri, 31 Aug 2001 09:19:27 +0800
|
|
You can use sql loader.
Regards,
HK Chang
> -----Original Message-----
> From: khan deepu [SMTP:khandeepu@h...]
> Sent: Thursday, August 30, 2001 4:54 AM
> To: ASPToday Discuss
> Subject: [asptoday_discuss] transfering data
>
> hi,
> i have some data's in ms access.i want it to migrate it to oracle
> database.is their a way to do it.please help me.
>
>
> $subst('Email.Unsub')
|
|
|
View Cart
