Fast Software needed to Convert CSV to MDV

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Mclean Buono
Answered By 0 points N/A #157143

Fast Software needed to Convert CSV to MDV

qa-featured

Hello,

You can use OleDB  for importing text files such as CSV for more details go to this site: http://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

Best Answer
Best Answer
Answered By 10 points N/A #157144

Fast Software needed to Convert CSV to MDV

qa-featured

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.

Login/Register to Answer

Related Questions