We use Pluggers Excel plugin - works really well for both importing and creating Excel documents: https://www.pluggers.nl/product/xl-plugin/
The problem with exporting form Excel to a text file is if any of the cells contain return or line feed characters, that will mess everything up as 4D will then think that each of those returns or line feeds represents the end of a row (record). No problem if you don't have any text fields like that in your spreadsheet :) Pat On 7 March 2018 at 10:36, Koen Van Hooreweghe via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Ferdinando, > > Export from Excel to text file (comma delimited, tab delimited). And then > use the 4D import tool or write your own code (receive packet,…) > > HTH > Koen > > > Op 7 mrt. 2018, om 11:06 heeft stardata.info via 4D_Tech < > 4d_tech@lists.4d.com> het volgende geschreven: > > > > I use 4D V15 or V16 someone know how i can to import from excel? > > > > -------------------- > Compass bvba > Koen Van Hooreweghe > Kloosterstraat 65 > 9910 Knesselare > Belgium > tel +32 495 511.653 > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** > -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
