jimsau said:
The driver is present but I am far from an expert on databases so I have no idea how to do it especially when I cannot open the file and view the structure to know what and how to convert it. I was lucky to figure out access as far as I did.
I'm no expret either, but I think I can help you make a little progress. If you set up a DSN for the database using the driver you have, you can learn a few things about the database. That's not to say you can find out everything, but perhaps you can learn enough to move ahead. Once the database is available through ODBC, you can create a new database in MS Access and import the tables from the old database. The thing I'm not sure about is how you can get the relationships. But knowing what tables are in the old database might get you started.
In ODBC Data Sources (from Windows Control Panel), set up a User DSN, pointing to the sybase db and using the sybase driver. I don't use ODBC very often, so I can't be more specific about this task, but the wizard-like process makes most of it pretty self-evident.
Once that's done, go to MS Access and create a new database. Then go to the Tables tab, click the New button and choose Import Table. A file dialog will open. At the bottom, you will see a dropdown of file-types (*.mdb, *.dbf, etc.). In the list (usually at the bottom), you will find ODBC. Select that and another dialog will show. This dialog allows you to select a data source. The DSN you set up for the sybase file should be in the list. Select it and Access should show you all the tables and allow you to import them.
As I stated before, this will allow you to import the tables, but I'm not sure how you can get the relationships. I don't know how much help this is for you, but perhaps it will move things along a little.
riley
