.db file to access or excel
- Thread starter rehanemis
- Start date
- Local time
- Today, 08:03
- Joined
- Feb 28, 2001
- Messages
- 30,567
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, 08:03
- Joined
- Feb 28, 2001
- Messages
- 30,567
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:
