Re: Converting Access to SQL

Thomas Kinnen ( (no email) )
Wed, 21 May 1997 13:20:56 -0400

>
> Search www.microsoft.com for "upsizing access". There is a utility to
> automatically do this, but be prepared to wait for a few hours while
> it's running.
>

Another option (One that I use) is to get your hands on a copy of
PowerBuilder by PowerSoft/Sybase. In it's development tools is a data
pipeline painter that will copy tables, data, and do data type conversions
between two ODBC data sources. I've used it to copy a couple of Access
databases to SQL Anywhere 5.5 with no problems. Just chenged the ODBC
source in the INI files and the apps fired up with no problems.

Tom