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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.