Come join us Saturday, December 13, 2008, at 10:00 for our monthly GRAFUG meeting. (www.grafug.com).
Mike Potjer will present: . Reading/writing Excel 2007 (and earlier) files without using automation Mike will demonstrate how Excel 2007 (and earlier) spreadsheets can be read from and written to using the Microsoft Excel ODBC drivers. The primary advantage to this technique is that the user is not required to have any version of Excel installed on their PC. The older version of the ODBC driver, which supports Excel 2003 and earlier, is included with all versions of Windows going back to Windows 98. The newer ODBC driver, which supports all version of Excel through 2007, is installed with Office 2007, and is also available as a free download from the Microsoft Download Center. Using the ODBC drivers can provide functionality similar to VFP's COPY TO and APPEND FROM commands, but with the added ability to retrieve the list of worksheet names, as well as creating or writing to a worksheet with a name you specify. Since the ODBC drivers treat worksheets as tables, rows as records, and columns as fields, this dovetails nicely with VFP's powerful data handling capabilities. Do you have a cool tool? Something you want to brag about? Please share it with the group! It's amazing how little ideas can grow into better ones. Elections are here! Please come and show your support. Currently held positions: President: Cathy Pountney - is stepping down. will really be missed. Vice President: Jody Meyer Secretary: Cathy Pountney - is stepping down. will really be missed. Treasurer: Mike Potjer Webmaster: Jody Meyer Be a Volunteer If you wish to volunteer to be a speaker for a future meeting, information and a link for topic submission can be found on our website: http://www.GRAFUG.com <http://www.grafug.com/> . Our meetings are held at: Optimal Solutions, Inc. 1055 Gezon Parkway Wyoming, MI 49509 Phone: 616-281-6040 Cathy Pountney --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
