Douglas, I can save the Excel file as a CSV, so I'll try that. Thanks! Alan
On Mon, Sep 11, 2017 at 1:10 PM, Douglas von Roeder via 4D_Tech < [email protected]> wrote: > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
