View Single Post
Old February 3rd, 2004, 12:05 PM
tjs206 tjs206 is offline
Registered User
Join Date: Nov 2003
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts

What I think you want in the command button is to import, not export.

Using a macro with the TransferSpreadsheet action is the way to go.

Use these arguments for TransferSpreadsheet:

Transfer Type: Import
Spreadsheet Type: Choose whichever version of Excel that you are importing from.
Table Name: Input the name of a table that you want to import into (can be a new table or an existing table - name the table anything you want, if existing table it will append the data).
File Name: You put the exact path of where the file is located. For example \\myServer\C\myExcelSpreadsheet.xls.
Has Field Names: If the first row of your spreadsheet has columns name then you would answer YES.
Range: This is if you only want to include a range of cells. If you want the entire spreadsheet - leave blank, it will take the whole spreadsheet by default.

Hope this helps.