Import multiple csv into multiple tables

Giganews Newsgroups
Subject: Import multiple csv into multiple tables
Posted by:  Chicagoboy27 (…
Date: 8 Aug 2006

Is there a way to import multiple csv files from a directory into sql
2005? The situation I have right now is that I have a folder with
multiple csv files that i need to import into sql 2005. I can do  it
with the import wizard but it takes to long. The files will be updated
monthly. The first row in the files contains all the header information
which may change monthy. What I am looking to do is import all of these
csv into tables. One csv file into  for one table. Ideally I would like
to use the name of the csv file as the name of the table. Any bump in
the right direction would be apprecieted