Alan: A long time ago (mid-90's) there was a bug in the Excel SYLK import such that if your first character was a number (or alpha), the import would fail. I can't recall which character type caused the issue.
Is there a way to do a TTR or CSV import? -- Douglas von Roeder 949-336-2902 On Mon, Sep 11, 2017 at 10:02 AM, Alan Tilson via 4D_Tech < [email protected]> wrote: > ​Hello everyone, > > I'm trying to import timesheet data from an Excel file saved as a SYLK > file. > > Sometimes it works perfectly loading the variables in my Input Form and > sometimes they are all blank. Same SYLK file, same form, same code. > > Any ideas about what to look into would really be appreciated. > > At times it seemed to be working consistently. Today it stopped working and > I can't get it to work again. > > I'm importing into a Temp table, loading the variables, then saving into > another table, fyi. > > Thanks, > Alan > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

