Alan, Take a look at XL Plugin from Pluggers (https://www.pluggers.nl/product/xl-plugin/). It is an excellent tool for working with Excel, writing or reading directly.
HTH and happy holidays, Lahav -----Original Message----- From: 4D_Tech <[email protected]> On Behalf Of Alan Tilson via 4D_Tech Sent: Monday, December 24, 2018 12:45 PM To: 4D iNug Technical <[email protected]> Cc: Alan Tilson <[email protected]> Subject: Re: Pasting Spreadsheet Data into 4D Records Hello Pat, Koen & Ken, Pat & Ken- Thank you for your response but I'm trying to eliminate (especially manually) creating the text file. I had been thinking of automating the creation of the text files and using import, but... Koen- I hadn't thought of manually (via code) parsing the text data rather than trying to use import commands. That seems worthwhile and not that difficult! I probably should have said that I potentially have hundreds of copy/paste operations to do! Your responses are much appreciated, Alan On Mon, Dec 24, 2018 at 11:37 AM Kenneth Geiger via 4D_Tech < [email protected]> wrote: > Hi Alan, > > Just save your spreadsheet (Excel) as file-type Tab-Delmited-Text (.txt). > Then in 4D, navigate to File…Import…, change the file type to .txt, > select your saved file, select the table into which to import the > data, and then match the data (columns) to the proper field and import it. > > Regards, > > Ken Geiger > > > On Dec 23, 2018, at 5:47 PM, Alan Tilson via 4D_Tech < > [email protected]> wrote: > > > > Greetings everyone, > > > > Is there a way to copy from a spreadsheet like data source and to > > paste directly into 4d while parsing it into table(s) and fields? > > I'm using v17 if that matters. > > > > I thought about saving the data into a text file and then importing > > the text file, but there seem to be unnecessary steps in there! > > > > Thanks, did some searches but didn't find anything, Alan > > ******************************************************************** > > ** > > 4D Internet Users Group (4D iNUG) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:[email protected] > > ******************************************************************** > > ** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
