ACCESS TO SEQUEL

[cell0042]

I was wondering If I could change my backend to sequel. If that could be possible. I've heard that it could be done. But I don't know.

 

[smedvid]

Depending on how complex your database is... look at using the MS Access Upsize Wizard. I've used it before for little systems and it was fine... htwh, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[pweegar]

Or use DTS services from SQL Server. It also works fine. I've seen lots of strange things happen converting Excel data to Access tables....

 

[Terpsfan]

Cell, what version of Access are you using? I think you're much better off using the Access Upsizing Wizard, because it retains your table relationships, primary keys and even upsizes some of your queries. If you are upsizing to SQL 2000 and have Access 2000, just make sure you have Access Service Release 1. And it automatically creates linked tables to SQL or gives you the option to set up an Access data project.