[AccessD] Linked tables have no rows and just field F1

[Bill Benson]

Gustav explained to me that I was linking the first sheet in the workbook
rather than all sheets in my array of sheet names! Kudos for spotting that.

On Mon, Jan 22, 2018 at 9:51 PM, Bill Benson <bensonforums at gmail.com> wrote:

> I am trying to link to excel worksheets with this command
>
>       DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12Xml,
> vListSheets(i), DATA_FILE, True
>
>
> vListSheets(i) is a particular worksheet. It has headers, and most of the
> sheets have data.
> DATA_FILE is the Excel file's path.
>
> What happens is each linked table has a field named F1 and the tables are
> empty. Probably a rookie mistake I am making... though I am not a rookie,
> so I am a little embarassed here. It has been 10 years or more since I used
> TransferSpreadsheet to link to an Excel file.
>