Share this Page URL

Chapter 4. Importing and Linking to Data > Linking to Data - Pg. 131

Importing and Linking to Data 131 5. 6. 7. In the Transfer Type argument, keep Import selected. (The other choices are Export and Link.) Keep the default value for the Spreadsheet Type argument--Microsoft Excel 8-10. (You could also choose other versions of Excel or Lotus 1-2-3 formats.) In the Table Name argument, enter CampaignExpenses. This table is the one we'll import the data into. In the File Name argument, enter C:\Microsoft Press\AccessInsideTrack\Chap04\Marketin- gExpenses.xls. (If you copied the sample files to a different folder, enter that path and the reference to MarketingExpenses.xls instead.)