import from MS Access

#1

Hello,
As we know we can design package than does table->table conversion. But how
to get a conversion of all tables -> all tables?
thank you!

#2

In message <A756BADB-E606-41A4-8A47-A79DBC652CC2 (AT) microsoft (DOT) com>, Dmitry
Islentiev <DmitryIslentiev (AT) discussions (DOT) microsoft.com> writes

Quote:

Hello,
As we know we can design package than does table->table conversion. But how
to get a conversion of all tables -> all tables?
thank you!

The Import/Export Wizard?

Note that DTS is not an upsizing tool for Access, just data transfer. If
you want properly migrated structures then there is an Access upsizer
from MS instead.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#3

so Darren then there is no way that you know of outside the upsizing tool to
import stored procedures from Access to SQL2000? the "import objects" thru
the Import/Export wiz is greyed out - thanks for your help.

John

"Darren Green" wrote:

Quote:

In message <A756BADB-E606-41A4-8A47-A79DBC652CC2 (AT) microsoft (DOT) com>, Dmitry
Islentiev <DmitryIslentiev (AT) discussions (DOT) microsoft.com> writes
Hello,
As we know we can design package than does table->table conversion. But how
to get a conversion of all tables -> all tables?
thank you!

The Import/Export Wizard?

Note that DTS is not an upsizing tool for Access, just data transfer. If
you want properly migrated structures then there is an Access upsizer
from MS instead.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#4

No way I know, but then I haven't looked very hard. It is one way, and
probably quite a good one as well, but no doubt there are other options, and
probably some third-party tools that may suit your requirements.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"John F." <juantana (AT) newsgroups (DOT) microsoft.com> wrote

Quote:

so Darren then there is no way that you know of outside the upsizing tool
to
import stored procedures from Access to SQL2000? the "import objects"
thru
the Import/Export wiz is greyed out - thanks for your help.

John

"Darren Green" wrote:

In message <A756BADB-E606-41A4-8A47-A79DBC652CC2 (AT) microsoft (DOT) com>, Dmitry
Islentiev <DmitryIslentiev (AT) discussions (DOT) microsoft.com> writes
Hello,
As we know we can design package than does table->table conversion. But
how
to get a conversion of all tables -> all tables?
thank you!

The Import/Export Wizard?

Note that DTS is not an upsizing tool for Access, just data transfer. If
you want properly migrated structures then there is an Access upsizer
from MS instead.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

import from MS Access

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

import from MS Access - 12-02-2004 , 02:47 AM

Re: import from MS Access - 12-12-2004 , 04:04 PM

Re: import from MS Access - 03-11-2005 , 02:39 PM

Re: import from MS Access - 03-11-2005 , 02:53 PM