Access upsizing using DTS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: m3ckon (anonymous_at_devdex.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 07:06:17 -0700

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!

Relevant Pages