Convert MDB to CSV

Question

I have a MS Access mdb file. I need to convert it to a CSV file. How do i do it? Please do not point me to any freeware.

Thanks in advance

You can find another version of VBA code to dump tables as CSV files here: http://stackoverflow.com/questions/6470469/how-fast-is-sqlite-compared-to-microsoft-access-mdb/6471310#6471310 — HansUp, Sep 30 '11 at 16:41

score 6 · Answer 1 · answered Dec 07 '13 at 10:42

6

Another useful tool is mdbtools:

http://mdbtools.sourceforge.net/

answered Dec 07 '13 at 10:42

oz123

27,559
27
125
187

2

mdbtools is available on Ubuntu: sudo apt-get install mdbtools – AndrewL Dec 12 '13 at 23:15

score 4 · Answer 2 · edited Dec 14 '16 at 02:27

4

Plotly (https://plot.ly) will convert your MDB files to CSV for free.
EDIT: free Plotly users cannot use this functionality; a subscription is required.

edited Dec 14 '16 at 02:27

albert

8,112
3
47
63

answered May 26 '13 at 01:09

freemdb

66
2

Uwe Keim · Answer 3 · 2011-06-02T07:54:19.450

4

Being no freeware, as you requested, I could recommend you Spectral Core's Full Convert Enterprise.

I've used it successfully in the past, too.

Update:

Since you clarified that you need a programmatic solution, I do recommend you do it manually:

Open a connection to the MDB file through ADO.NET.
Iterate all tables.
Create a text file (CSV) for each table.
For each table, iterate all rows.
For each row, write a new line in the text file.
For each row, iterate all columns.
For each column, write the value to the text file in the current row.

edited Jun 02 '11 at 07:54

answered Jun 02 '11 at 07:45

Uwe Keim

39,551
56
175
291

@Keim ... I meant is that I want Code which will do the conversion. I do not need any tool to do that. Can any one help me with that? – Rajdeep Jun 02 '11 at 07:48
Thankx Keim...I did it. But Now I am stuck in a whole new situation.. Now i have to read from that CSV file and convert it in to a MDB file. Any help regarding this? – Rajdeep Jun 03 '11 at 06:19
@Rajdeep Try posting a new question and/or searching the Internet for a solution. – Uwe Keim Jun 03 '11 at 06:20
@Keim. I didnt get your point. – Rajdeep Jun 03 '11 at 06:24

Duke · Answer 4 · 2012-02-11T20:20:54.293

4

use this utility its opensource and free mdb to csv convertor: MDBtoCSV

edited Feb 11 '12 at 20:20

answered Feb 09 '12 at 10:46

Duke

1,731
2
17
33

This link doesn't exist any more. – waz Apr 04 '22 at 01:23

Fionnuala · Answer 5 · 2011-09-30T17:54:56.307

3

With VBA

Dim db As DAO.Database
Dim tdf As TableDef

Set db = CurrentDb

For Each tdf In db.TableDefs
    If Left(tdf.Name, 4) <> "MSys" Then
        DoCmd.TransferText acExportDelim, , tdf.Name, tdf.Name & ".csv"
    End If
Next

-- http://msdn.microsoft.com/en-us/library/aa220768%28v=office.11%29.aspx

edited Sep 30 '11 at 17:54

answered Sep 30 '11 at 16:21

Fionnuala

90,370
7
114
152

+1 Actually I prefer my version, but admit that I'm biased. :-) However I still think it's useful to skip dumping "~" tables to CSV, and to include field names in the CSV files. – HansUp Sep 30 '11 at 16:47
@HansUp This is an antique question with a throw away answer :) I do not have any "~" tables, I never have had. Do you mean queries? – Fionnuala Sep 30 '11 at 17:48
No, I meant tables. When you delete a table, it persists in the TableDefs collection with its original name prefaced by "~". I'm unsure how long they persist in that fashion; compact seems to remove them. But I reckoned, if there is a deleted table still present in TableDefs, there wouldn't be value in saving it as CSV. – HansUp Sep 30 '11 at 18:44
Interesting. They do not last past a close and reopen, so they must be tables very recently deleted. – Fionnuala Sep 30 '11 at 18:58

Convert MDB to CSV

5 Answers5

Linked