Andy Davies wrote: >>Using Jaime's method doesn't involve any export/import of physical >>data files. >>Dave Crozier > > > Dave, > does rs.Open("select * from credidt.dbf",...) do less under the hood than > use credidt.dbf then? > > .. and does anyone know if the excel .CopyFromRecordset method also > truncates cells to 256 characters? >
No, it's limited to the limit of the cell, 32767 characters. Only 1024 display in cell, all 32767 display in the formula bar. HTH Saludos, Jaime Vasquez Guatemala C.A. _______________________________________________ Post Messages to: ProFox@leafe.com 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.