Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Convert MDB File To Txt File

by jZed (Prior)
on Apr 28, 2005 at 04:59 UTC ( #452218=note: print w/replies, xml ) Need Help??


in reply to Convert MDB File To Txt File

Well, I think Access can export to CSV so that's the easiest. If you don't have access to Access, you use DBI with DBD::ODBC to read the .mdb and DBD::CSV to write out the .txt file.

Replies are listed 'Best First'.
Re^2: Convert MDB File To Txt File
by gopalr (Priest) on Apr 28, 2005 at 06:11 UTC

    Let me know how do you convert without "Access"..

    Thanks

      You should take a look at MDB Tools.

      Not entirely without problems, it's reliable enough that I use it in an ongoing project that I have to keep an eye on anyway. You can backtick to the command line utilities or use a GUI thingy. Looks like something that would benefit from having a Perl module in front of it...


      MB
      update

      I just discovered this one: Openoffice.org, which is available on both windows and *nix, apparently has an experimental .mdb reader and it can write in many formats.

      Did you read the second sentence of my reply? It specifies what to do if you don't have Access. Did you follow the links in that second sentence? They go to the documentation for the modules that will help you do what you want. Did you read that documentation and get stuck? If so, tell us what part you're stuck on and we'll be glad to help. You also need to tell us what OS you are using since the specifics of the answer differ depending on whether you are on windows or not.
Re^2: Convert MDB File To Txt File
by Anonymous Monk on Apr 28, 2005 at 06:26 UTC

    Can you give Some Sample Coding.. It Would be very better to develop further.. Thanks You!!

      What have you tried so far?
      I don't think anyone is going to write your code without any effort from you

      "We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise." - Larry Wall.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://452218]
help
Chatterbox?
[davido]: so last -f /var/run/utmp on ubuntu provides similar (though more verbose) info
[oiskuu]: glibc getlogin just does ttyname() and falls back on getutline(); it's not security related at all. (reminds me of sendmail and remote finger services of the naive early spam era)
[Corion]: But yes, "who started this process" is interesting information :)
[tye]: no, I really believe that "login user" was added as a fundamental bit of info about each process in order to enhance the usefulness of auditing
[Corion]: Ah - if that information is saved in a file, then you could theoretically spam that file and confuse getlogin(). So, don't use it for authentication :)
[tye]: that is what getlogin() certainly *used* to do. I don't believe that is what it certainly should do.
[davido]: /var/run/utmp is 664 i think.
[tye]: Note that my "man getlogin" says that it uses stdin when it should use /dev/tty (calling a glibc bug). But that does not appear to be the case when I test it. But maybe Perl's getlogin() is not using glibc's getlogin().
[oiskuu]: well, run a strace and see what the getlogin does for you.... As I said. SELinux probably has those security labels. But not regular linux.
[tye]: for example, read https://unix. stackexchange.com/ questions/146138/ loginuid-should-be -allowed-to-change -or-not-mutable-or -not

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (9)
As of 2017-06-23 19:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (554 votes). Check out past polls.