Search results

I came across the same problem when I was trying to link a table from an Excel file with multiple worksheets. Here's how I did it using TransferSpreadsheet. DoCmd.TransferSpreadsheet _ TransferType:=acLink, _ SpreadsheetType:=acSpreadsheetTypeExcel12Xml, _ TableName:=tbl_link_name...