Hi,

I'm upgrading an Access 97 system to SQL Server 2000 and am encountering
a few problems.

Initially I tried using the tool from microsoft in Access, but I kept
getting overflow errors. Instead I thought I'd use the DTS instead.

I've established a connection to my access mdb and to the sql server,
but I can only transform data one table at a time and I have over 200
tables to transform.

Can someone tell me an easier way of doing this please??

M3ckon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can, and I do, use the wizard instead. This will generate all the
DataPump tasks for you.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"m3ckon" <anonymous (AT) devdex (DOT) com> wrote

DTS is going to be the way to do it as you are just hitting
a known issue when upsizing from Access 97 to SQL Server
2000. See the following:
ACC97: "Overflow" Error Message When You Try to Upsize to
SQL Server 2000
http://support.microsoft.com/?id=279454

If you going to still use an Access 97 front end, you need
to watch the data types when using DTS though. You'll have
unicode data types by default which aren't supported when
linking tables to an Access 97 front end.

-Sue

On Mon, 10 May 2004 07:06:17 -0700, m3ckon
<anonymous (AT) devdex (DOT) com> wrote: