Linked table to Excel Sheet
This line will create a linked table to specified worksheet (MySheetName) in Excel workbook:
DoCmd.TransferSpreadsheet acLink,acSpreadsheetTypeExcel9, "MyTable", "C:\MyFile.xls", , "MySheetName$"
posted by Alex Dybenko | 18:20
0 Comments:
Post a Comment
<< Home