>>Has anyone imported data from the new Excel files? (Or exported into Excel for that matter)<<
The old way of exporting to Excel with the COPY TO command still works with Excel 2007. You are limited to the number of rows the older versions of Excel supported. As for reading the new Excel format, this is easily done with the Excel ODBC driver. http://support.microsoft.com/default.aspx?scid=kb;en-us;949529 OR http://is.gd/FQNr You also might be interested in Craig Boyd's blog: http://www.sweetpotatosoftware.com/SPSBlog/2008/09/30/UsingExcel2007FileForm atsInVFP90.aspx OR http://is.gd/FQyv >> It seems odd to me that with all these clever foxpro people around, we still don't seem to have worked out how to import the data from Access I looked everywhere this morning and the best I can come up with is the mdb2dbc utility, which of course is useless now that Access has changed to a new format.<< Not exactly sure what your problem is for Access to VFP database or your full requirements (I have not looked at MDB2DBC), but here is some simple code to create structures and move the data: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q260405 OR http://is.gd/FRNy Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ 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/028901c9de61$50d218f0$f2764a...@com ** 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.
