Convert MDB to CSV [closed]

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

Answer 1

Another useful tool is mdbtools:

http://mdbtools.sourceforge.net/

Answer 2

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:

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