AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, March 09, 2010

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$"

Labels: ,

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home