Share this Page URL

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

Importing and Linking to Data 110 · XML documents. (We'll cover importing XML documents in Chapter 16, "Working with XML Data in Access.") · Open Database Connectivity (ODBC)--compatible data sources such as Microsoft SQL Server and Microsoft Visual FoxPro. After you select the type of file you're importing and the file that contains the data, click the Import button in the Import dialog box. At this point, for file types such as Excel workbooks, text files, and HTML documents, Access displays a wizard that you step through to import the data. The steps you follow in the wizard are similar for many types of files. We'll use an Excel worksheet as an example in the next section. You'll see what information the wizard requires and the options you have for importing data. You'll see also what you can do to prepare data to be imported so that you'll have a cleaner import process and not have to take time to clean up the data in Access. Importing data just in time Importing data that you'll store and maintain in your database is one way to populate some or all of the tables with data. You can also import data periodically, using it in reports or for other analytical needs, and then delete or archive the imported data. Importing Data from Microsoft Excel To begin this procedure, open the HelloWorld4 database, which is found under Chap04 in the folder where you copied the sample files for this book. In the Database window, shown in Figure 4-2, you'll see the tables we're using to track marketing campaigns. We'll add data to the CampaignExpenses table in this section by importing data from an Excel worksheet.