Convert MDB File To Txt File

Comment on Convert MDB File To Txt File
Re: Convert MDB File To Txt File by jZed (Prior) on Apr 28, 2005 at 04:59 UTC
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.	[reply]
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	[reply]
Re^3: Convert MDB File To Txt File by matthewb (Deacon) on Apr 28, 2005 at 07:58 UTC
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	[reply]
Re^3: Convert MDB File To Txt File by jZed (Prior) on Apr 28, 2005 at 14:21 UTC
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.	[reply]
Reaped: Re^3: Convert MDB File To Txt File by NodeReaper (Curate) on May 23, 2013 at 09:20 UTC
This node was taken out by the NodeReaper on May 23, 2013 at 12:25 UTC Reason: [marto]: Reap: SPAM probe. You may view the original node and the consideration vote tally.	[reply]
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!!	[reply]
Re^3: Convert MDB File To Txt File by jbrugger (Parson) on Apr 28, 2005 at 08:53 UTC
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.	[reply]
Re: Convert MDB File To Txt File by gube (Parson) on Apr 28, 2005 at 05:19 UTC
You can use DBI module and also using DBD::ADO or DBD::ODBC you just pass the query and read the text and you write it to the text file is better. To know detail about connect database go to the link How to link Ms-access data's in perl	[reply]
Re: Convert MDB File To Txt File by inman (Curate) on Apr 28, 2005 at 09:06 UTC
There follows some old code that I had knocking around on my machine from a proof of concept. This code was from a risk management project where there was a concern that the content of Access databases could not be analysed by the risk management search tool. The idea was to locate and dump any MDB to an XML file which could then be indexed without having to know anything about the database schema. The code is probably well dodgy... Read more... (3 kB)	[reply] [d/l]


We don't bite newbies here... much
	PerlMonks

Convert MDB File To Txt File

The best material for plates (tableware) is: