Convert MDB to CSV

Question

I have a MS Access mdb file. I need to convert it to a CSV file. How can I do it? Please do not give me any free software.

Thanks in advance

Answer 1

Not being free, as you requested, I could recommend you Spectral Core Full Convert Enterprise .

I have used it in the past too.

Update:

Since you clarified that you need a software solution, I recommend that you do this manually:

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

Answer 2

use this utility in your openource and free mdb for csv converter: MDBtoCSV

Answer 3

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

Answer 4

Another useful tool is mdbtools:

http://mdbtools.sourceforge.net/

Answer 5

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