I have an Excel 2003 spreadsheet that has in colum E3 : E10 data that I want to auto import into a table. I have this code
.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "ImportData", FilePath, False, "Employee info!E3:E10"
but it puts in one column. I want it to go to one record in 8 different columns