Importing from Excel with header column rather than row

  • Thread starter Thread starter woalmoore
  • Start date Start date
W

woalmoore

I know how to import and excel spreadsheet into an Access table. However,
the worksheet I have (do to some other considerations) has the header in the
first column rather than the first row. Is there a way to import that data
so that the records come from each column rather than from consecutive rows
(preferably without having to transfer all of the information to a second
worksheet in rows...a tedius process to be sure)?
 
Neither easily nor directly.
Your normal TransferSpreadsheet expects columnar data. You can either
transform your data in Excel or you can use Automation from Access to do it.

You could use automation to open the workbook, transform the data into
columns, save the workbook and then use the TransferSpreadsheet to import it.
 
Back
Top