R
Rambo
Hello,
I am trying to place a button on my form that a user could click which
would automate the import of an excel spreadsheet.
I am fairly certain that I will use the TransferSpreadsheet command
DoCmd.TransferSpreadsheet, acImport, microsoftexcelspreadsheet3,
filename, tablename, true
However, I would like the open file dialog box to popup so that the
user can browse for the specific file (My thinking is that whatever
file the user chose would define the filename variable?) that is to be
imported and also I would like a dialog box to pop up so that the user
could define the table name with to which the data is to be imported.
Can anyone be of assistance? I am trying to learn how to program so
any help would be greatly appreciated.
Sincerely,
Rambo
I am trying to place a button on my form that a user could click which
would automate the import of an excel spreadsheet.
I am fairly certain that I will use the TransferSpreadsheet command
DoCmd.TransferSpreadsheet, acImport, microsoftexcelspreadsheet3,
filename, tablename, true
However, I would like the open file dialog box to popup so that the
user can browse for the specific file (My thinking is that whatever
file the user chose would define the filename variable?) that is to be
imported and also I would like a dialog box to pop up so that the user
could define the table name with to which the data is to be imported.
Can anyone be of assistance? I am trying to learn how to program so
any help would be greatly appreciated.
Sincerely,
Rambo