Importing multiple csv files into table

[VBAFunkymonk]

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.

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

 

[ghudson]

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=90407

 

[Robert88]

Hi Funkymonk,

Below are two good connections for food for thought on your problem.

http://www.access-programmers.co.uk...p?t=44270&highlight=import+multiple+CSV+files

http://www.access-programmers.co.uk...p?t=86561&highlight=import+multiple+CSV+files

Good Luck

Robert88