Groups > comp.databases.filemaker > #1926

Re: Solved: Import dates from spreadsheet apps

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news2.arglkargh.de!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Solved: Import dates from spreadsheet apps
Date	Sun, 16 Nov 2014 10:35:08 +1300
Organization	Aioe.org NNTP Server
Lines	28
Message-ID	<161120141035088483%HelpfulHarry@BusyWorking.com> (permalink)
References	<1lv5i5t.1sf2giv1s5z6viN%clkaufmann@gmx.ch>
NNTP-Posting-Host	J+DTz36L6fuS4BQ5o+Dk7A.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Thoth/1.5.4 (Carbon/OS X)
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.databases.filemaker:1926

Show key headers only | View raw

In article <1lv5i5t.1sf2giv1s5z6viN%clkaufmann@gmx.ch>, Christoph
Kaufmann <clkaufmann@gmx.ch> wrote:

> Problem: If you have a date field in Filemaker and import records from
> Excel, you get the dates correctly.
> 
> This does not work for xls or xlsx created with Numbers or
> LibreOffice[1]. I used to take the dates into pieces in the spreadsheet
> app (day, month, year), import these and put them together in Filemaker.
> What a drag.
> 
> Solution: save the sreadsheet as dbf rather than xlsx (yes, I slapped my
> forehead).
> 
> [1] Can no longer test this, I don't have Numbers. Filemaker 11 and 13
> on OS 10.7 refuse to accept xlsx files created by LibreOffice.

I think it's a bug in Excel, and a long-standing one. 

I've recently been working on Excel spreadsheets, both saved as .xls,
but one from a web-exported CSV file and one from an .xlsx. Dates
simply copied from the pre-CSV file and pasted into the pre-xlsx file
stupidly gained one day.  :o\

Dates imported from the pre-CSV file (saved back to a CSV) into
Filemaker worked properly.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Solved: Import dates from spreadsheet apps clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-11-15 14:41 +0100
  Re: Solved: Import dates from spreadsheet apps Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-11-16 10:35 +1300

csiph-web