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 <4d_tech-boun...@lists.4d.com> On Behalf Of Alan Tilson via 
4D_Tech
Sent: Monday, December 24, 2018 12:45 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Alan Tilson <alantil...@gmail.com>
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 < 
4d_tech@lists.4d.com> 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 <
> 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com
> > ********************************************************************
> > **
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to