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 Windows XP as is. Windows Vista still supports Visual Basic 6.0 (and by extension VBA), but does not ship with all of the data access components of its predecessors. To run the examples under Windows Vista, check the following link to Microsoft's Support Statement for Visual Basic 6.0 on Windows Vista: http://msdn2.microsoft.com/en-us/vbrun/ ms788708.aspx.
Was this article helpful?