Migrating Sybase ASA to Microsoft Access

[codercode]

I'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way
too much for that. Is there anyway I can migrate from a Sybase to
Access? or is it possible at all. If it is not, can these two databases
co-exist together?

 

['69 Camaro]

Hi.

Is there anyway I can migrate from a Sybase to
Access?

I've never worked with Sybase, but I imagine there are ODBC drivers for it. If
so, one may create an ODBC linked table to each Sybase table to "see" the data
from Access. However, some drivers don't lend themselves to updateable
recordsets, so importing the data into Access tables may be the only
alternative.

If there are no ODBC drivers for it, export the data from each Sybase table into
a separate text tile, then import each text file into Access as a new table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.