title: insert xls/csv file into access 2007 table using vba
body: <p>I have several excel files carrying 90 columns and about 500 rows, each file has a header of 4 rows, and I need to insert them into one access table.</p>
  
  <p>I am able to do the import by using the for...loop to loop all the excel files and all of the rows inside the file, but this is too slow.</p>
  
  <p>I have used mysql in R and it can be done easily using "LOAD DATA LOCAL INFILE". I can convert the xls file into csv file without problem, but I can't find anything similar in Access as "LOAD DATA LOCAL INFILE".</p>
  
  <p>Any suggestions for optimizing the import process? Thanks!</p>