Share this Page URL

Chapter 5. Using Visual Basic to Automat... > Understanding Scope and Variables - Pg. 153

Using Visual Basic to Automate Your Database 153 9. Press Alt+F11 to switch to Access. Click View, Form View to open the Import form in Form view, and then click the Import Expenses button. You should see an input box asking for the table you want to import data into, as shown here: 10. 11. 12. 13. Enter CampaignExpenses, and then click OK. Click Yes in the message box asking whether you want to update records. You'll see the second input box. Enter Chap05/MarketingExpenses.xls, and then click OK. Open the CampaignExpenses table, and you'll see that the data from the spreadsheet has been imported, as shown here: