Hi,
I have a spreadsheet with multiple worksheets that I import into MS Access.
I'm new to VB but I can get the import to work fine using the 'TransferSpreadsheet' expression i.e. (TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA) (I've...