Need tool to export Access database
Is there some tool better than mdb-tools for exporting Access database tables? mdb-export is essentially useless. An example:
Code:
# mdb-export HWW\ Membership\ Database.mdb tbl_Member_List |head -2 |
Is the Windows machine where the DB was running still available?
If yes, may be this will help (may be you have already looked at this): http://cdn.cdata.com/help/DCB/odbc/p...nodbclinux.htm |
What happens if you add this parameter '-b octal' (see man page)
What types are the columns that have empty values? (in other words, what is the output of 'mdb-schema HWW\ Membership\ Database.mdb ') |
Quote:
Quote:
Code:
CREATE TABLE tbl_Member_List In fact, MemberID is not the primary key as far as this scheme shows. |
I downloaded mdbtools version 0.7.1 from github and that appears to shown column names and columns correctly. I'll do some more testing and post back if this solves the problem.
|
After more testing, it seems that version 0.7.1 fixes all the issue I was having with version 0.5. I got the 0.5 version from the SlackBuilds repository. I will see about suggesting the the package maintainer that he upgrade to the 0.7.1 version.
|
Quote:
something like: Code:
$ mdb-export -V Code:
luuk@ACER:/mnt/c$ uname -a |
Quote:
The SlackBuilds package maintainer is not the developer, so he cannot add a -V option. All he does is create a package from some repository, maybe even github, and insures it will run on Slackware. uname will tell you nothing about the mdbtools version. |
All times are GMT -5. The time now is 09:38 AM. |