Hi
I need to pull data from an Excel worksheet to a data table, using Access & VBA.
I am trying to use the "DoCmd.TransferSpreadsheet acImport" method, but...
My problem is that the sheet I need to get at is one of four in the workbook & is called "finance codes". I can pick up the data from sheet 1, but I can't seem to grab the data from the sheet I need....
All help gratefully received
TIA
Steve