Very Computer

Hi there,

for migration of an ASP-website I need to convert a quite small database
that is currently running on the SQL-Server 6.5 to a local Access7.0
machine.

Any idea.... ?

thanks in advance
Eric

Use Get External Data from the Access File menu and choose Import.  The
dialog that comes up lets you select ODBC for a source, and you can then use
an existing ODBC data source, or create a new one.

--
Bob Pfeiff, MCSD
Spectrum Technology Group, Inc.

oops... Sorry, I thought you were going the OTHER way!!!

The free Access97 "Upsize Wizard" (available from
http://support.microsoft.com/support/downloads I think, when the website
works - try during off-peak hours) works okay for small databases. For large
databases, it sucks, though, because it does the transfer in one
transaction, and thus requires HUGE log files, which cannot be shrunk down
in size after you're finished!!!

Examine the Modules section of the upsize wizard for global declarations
that allow you to modify a few important things you can't modify in the GUI
(like timeout values).

-Charlie Barrett