Re: From Access to SQL Server

#1

mark,
you don't need to export from access. You can import Access databases from
SQL Enterprise manager using the Import/Export Assistant. From there you can
select the tables you want to import.
Hope this helps

"Mark" <markpirvine (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:e2HnC2IRDHA.4024 (AT) tk2msftngp13 (DOT) phx.gbl...

Quote:

Hi,

I am moving a Access to SQL Server (at the moment 7 but soon 2000). There
are primarily two tables, which are linked (1-to-Many), e.g. credit and
credit_details. Is there any way I can export the data from Access and
then
import it into SQL Server and still preserve the two tables? I would like
to avoid using the Upsizing wizard, as I need to play about with the data
a
bit first.

Many thanx,

Mark

#2

Heiko,

Many thanks for your prompt reply - will give it a go :-)

Mark

"Heiko Oberleitner" <heiko.oberleitner (AT) mecomo (DOT) com> wrote

Quote:

mark,
you don't need to export from access. You can import Access databases from
SQL Enterprise manager using the Import/Export Assistant. From there you
can
select the tables you want to import.
Hope this helps

"Mark" <markpirvine (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:e2HnC2IRDHA.4024 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

I am moving a Access to SQL Server (at the moment 7 but soon 2000).
There
are primarily two tables, which are linked (1-to-Many), e.g. credit and
credit_details. Is there any way I can export the data from Access and
then
import it into SQL Server and still preserve the two tables? I would
like
to avoid using the Upsizing wizard, as I need to play about with the
data
a
bit first.

Many thanx,

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: From Access to SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: From Access to SQL Server - 07-07-2003 , 08:58 AM

Re: From Access to SQL Server - 07-07-2003 , 09:05 AM