CHAPTER 2Data In, Data Out
Excel 2007 provides us with a number of methods to bring in data. We can import or link to many different data sources, including Microsoft Access databases, SQL Server databases, text files, ODBC databases, and XML files, to name a few.
Excel's Data Import Tools
Excel 2007 has a rich set of data handling tools. On the Developer ribbon, you'll find quick access to Microsoft Access databases, web tables, and text files. Excel also includes data access to SQL Server and OLAP databases, XML data, and ODBC data sources.
By recording macros, you can see how Excel connects us to various data sources. From there, you'll begin writing your own data access routines.
Note The first few examples will run under Windows 2000 or ...