Hi all,

I am completely new to Access and really don't know the first thing about it.

I have close to 200 spreadsheets in CSV format, each of which has 6965 rows and 34 columns of data. These 200 files are split up into six folders, name January thru June in particular directory.

I want to import everything into Access so that I can analyze all the data simulataneously. Is there a way to write a macro or something so that I can automate all of the imports? I want to combine all 200 excel sheets into one sheet in access, so that the first sheet is at the top, and the rest of the sheets are appended below the first sheet.

To give you a scope of how new I am to access, I tried copying one cell and pasting its contects to entire column, but I couldn't figure out how...

Thanks