Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1926

Re: Solved: Import dates from spreadsheet apps

Show all headers | 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