Import all files from a folder into multiple tables

[debauch]

Hello,

Is it possible to import all files from a specific folder (they are all .csv files) into a table of the same name of the csv? Im hoping it will create the table if it sees that it does not exist...if I have to create them manually, that is ok too, whichever is easier.

[OBP]

This should be possible, although a bit unusual. Are the Files on the same subject and format?
ie. could they not be appended to just one table?
I have VBA code that will find all the .csv files in a Folder and puts their names in to a Table, so adding the Import routine instead should not be too difficult.