Importing multiple CSV files

Hi

I have been given the task of setting up a database which will store data which I will receive on a month basis, I have managed to import some csv files however, I will be receiving well over 200 csv files each month. Is there a way to import these multiple file.

The filename save structure is as follows: areacode-Jul 05data.csv

areacode represents each different area.

below is a copy of the csv file.
Quote:
Area Name,Area Code,Date Enter,Enter_in_by,Case Number,H_Application,Date of App,H_Acknow,Date of Acknow,Delete,Amend Date,Managers name,Manager Contact,Managers Email,User Contact,User email,Delete
BRISTOL,1013,7/12/05,Tom,12ABC,Yes,Mar 05,Yes,Feb 05,Active,7/15/05,,,,,,leave
BRISTOL,1013,7/12/05,Tom,124ABC,Yes,Feb 05,No,No Date,Active,7/12/05,,,,,,leave
BRISTOL,1013,7/12/05,Tom,,134ABC,No,No Date,Yes,Jul 05,Active,7/12/05,,,,,,leave
BRISTOL,1013,7/14/05,Tom,THURSABC,Yes,Feb 05,Yes,Jan 05,Active,7/18/05,Catherine,02071223533,,,,leave
NORTH AVON,1021,7/14/05,Tom,FRIABC,No,No Date,Yes,Mar 05,Active,7/14/05,Catherine,02071234567,,0207172000,,leave
BRISTOL,1013,7/15/05,Bob,ABC123,No,No Date,Yes,Jan 05,Active,7/15/05,df,df,sdf,fg,df,leave
BRISTOL,1013,7/15/05,Bob,1ABC,No,No Date,Yes,Jan 05,Delete,7/15/05,df,df,sdf,fg,df,leave
BRISTOL,1013,7/15/05,Bob,ABCASE,Yes,Feb 05,No,No Date,Active,7/15/05,df,df,sdf,fg,df,leave
BRISTOL,1013,7/18/05,Bob,ABCASE2,Yes,Feb 05,No,No Date,Delete,7/18/05,df,df,sdf,fg,df,leave

If you could help me I owuld really appreciate it. I do know a bit about VBA (ONLY EXCEL).

My access
knowledge is somewhat limited, I can bang a form together and run basic
queries, but that's about as far as it goes.


Thanks in advance

Search the forum for your question has been asked and answered in many threads.

Also, please do not double post your question. You are only wasting the members time. Please delete one of your double posts.

http://www.access-programmers.co.uk/forums/showthread.php?t=90395

how do i do this?

I have search but can not find the answer any ideas? there may be a lot about importing but not relevant to my problem as most are based on one file or problem importing 1 file etc.

I just searched for the keywords "importing multiple files" and found 33 postings. Click the Search button near the top of the page.