Fast Software needed to Convert CSV to MDV

Asked By fox riley 0 points N/A Posted on - 02/04/2013

Large volume of CSV files need to convert to MDV format. What can be the best software to do it faster? I have converted a .mdb file to CSV format using ado.net and then looping on the recordset and writing the data in a .csv file.Now I need to do the reverse. I have to convert the CSV file to a .mdb file (an access table to be specific). Is there any programming code to help me out with this?

• Status: Open
• Question Views: 866
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: System Utilities

Best Answer by Mclean Buono

Go To Solution

Answered By Williamson Mellisa 5 points N/A #157143

Fast Software needed to Convert CSV to MDV

Hello,

You can use OleDB  for importing text files such as CSV for more details go to this site: https://www.codeproject.com/Articles/27802/Using-OleDb-to-Import-Text-Files-tab-CSV-custom and then write back to your MBD files. Other thing that you can do is to run the DoCMD Transfer Database command, deal with exporting data by importing Access Object library. It takes care in one command for everything.

I hope this will help,

Regards,

Williamson Mellisa

About Williamson Mellisa

Questions
2

Answers
201

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/04/2013
• Question Category: System Utilities

Best Answer

Best Answer

Answered By Mclean Buono 10 points N/A #157144

Fast Software needed to Convert CSV to MDV

Hi Fox,

Yes, there are several ways to import CSV file to a MDB file. Let's look at the available possibilities –

1. Download this small program available in Microsoft Knowledge Base – The download is an exe file which when executed extracts several files. It is essentially a Visual basic application with a form with you can choose the CSV file and specify details MDB file and thereafter choose the specific table in which data has to be inserted.
2. Importing CSV files into Access – This is not a program but a set of steps which can be followed to import CSV data into MDB file.

Hope this helps.

About Mclean Buono

Questions
6

Answers
99

Best Answers
33

• Vote Up 0 Vote Down

• Posted on - 06/25/2013
• Question Category: System Utilities