Depending on what kind of data you want to import, look in VBA Editor help for
TransferSpreadsheet - Excel or Lotus 123 files
TransferText - Text files
TransferDatabase - database objects
the users need to be able to determine whether or not the spreadsheet's
first row contains headers, etc. i thought the Transfer Spreadsheet
command just allowed you to pick the file then import with no options.