File | Get External Data | Import

  • Thread starter Thread starter mcourter
  • Start date Start date
M

mcourter

can i invoke File | Get External Data | Import from a button on a form?

how?

DoCmd or something?

tia,

mcnews
 
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.
 
Back
Top