.db file to access or excel (1 Viewer)
- Thread starter rehanemis
- Start date
- Local time
- Today, 02:46
- Joined
- Feb 28, 2001
- Messages
- 27,179
If that is a database type from something like Paradox or DB2 or such, they might (stress MIGHT) have a utility or built-in function to export tables in .CSV format, one table at a time. If so, Excel can read that pretty easily, though you might have issues for formatting. CSV exports almost always DO have formatting issues.
- Local time
- Today, 02:46
- Joined
- Feb 28, 2001
- Messages
- 27,179
Not personally familiar with SYBASE though I know a bit about the predecessor company. But that doesn't help.
If you have a copy of the SYBASE database manager, there should be a function that allows you to export data in some format. If the format is .CSV, that gets you to Excel in two steps: Export to .CSV, Import via Excel. If the format is something else, we would need to know what you can do.
If you don't have the SYBASE manager or have a stripped-down package, then the other possibility is that Access could read the file via ODBC.
I found this on a college web site:
http://web.cse.ohio-state.edu/~parthasarathy.2/670/Tutorials/ms_access_sybase_connect.txt
Perhaps this will help.
If you have a copy of the SYBASE database manager, there should be a function that allows you to export data in some format. If the format is .CSV, that gets you to Excel in two steps: Export to .CSV, Import via Excel. If the format is something else, we would need to know what you can do.
If you don't have the SYBASE manager or have a stripped-down package, then the other possibility is that Access could read the file via ODBC.
I found this on a college web site:
http://web.cse.ohio-state.edu/~parthasarathy.2/670/Tutorials/ms_access_sybase_connect.txt
Perhaps this will help.
Last edited:
- Local time
- Today, 03:46
- Joined
- Feb 19, 2002
- Messages
- 43,266
If you have Sybase installed, just load the db file. Then you can create an Access database and either import the data from Sybase if you want to convert it to ACE or just link to the Sybase database.
