Any way to import multiple (csv) files to an Access db

Question

I have multiple csv files with the same scheme, and I want to import them in one step. A solution could be to use the "import wizard", but I can only import one file with it. Oh, and it would be the best to work in msaccess2003. THX

Answer 1

You can write a small program for importing see http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html for java JDBC conector to msaccess and since the import file is csv you can do this in no time...

There are other importing options for other languages

Answer 2

The simplest solution is to start a dos-prompt, change to the directory where you have your files, and type:

type *.csv > allfiles.txt

If you do this often, you can create a batch-file that you can double-click from your desktop.

Answer 3

If all you want to do is drive the import with a list of files, you don't need a batch file. You can get the list of files using Dir():

  Dim strCSVFileName As String 

  strCSVFileName = Dir("*.csv")
  Do Until strCSVFileName  = vbNullString
     [import strCSVFileName]
     strCSVFileName = Dir()
  Loop

Of course, this assumes you're doing the import from within Access, but given your tags, that's the logical inference of your question.