May 24
Ed Bullock Importing 'Excel' Files
May 24, 2011; 00:43
Ed Bullock
Importing 'Excel' Files
Hi
A client receives a file from a 3rd party on a daily basis which is to be
imported into a FM database.
The file has a .xls extension but FileMaker refuses to import this file with
the error "This file could not be translated using the selected file type"
Of course I tried setting the file type as Excel and also as all files.
Neither works.
If I open the file in Excel and save it (without changing anything) then try
to import, it all works just fine
It seems to me that the third party supplying the file is exporting this
from an unknown system and just adding the xls extension on so that it can
be opened in Excel. It is not a true Excel file. By my opening this in
Excel, saving and closing it is making this file into a true Excel file and
so FileMaker can now import from the spreadsheet.
As we are trying to make the system as automated as we can, the fact that
the client has to open a file, save it and close it is not ideal by any
means.
Has anyone come across this kind of issue before and does anyone know of any
possible work around, hopefully without the need for any user interaction.
It is not going to be possible for anything to change on the side of the 3rd
party.
Many thanks
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>
May 23
Agnes Riley Re: Importing 'Excel' Files
May 23, 2011; 20:16
Agnes Riley
Re: Importing 'Excel' Files
May 23
Jonathan Fletcher Re: Importing 'Excel' Files
May 23, 2011; 20:48
Jonathan Fletcher
Re: Importing 'Excel' Files
May 23
Drew Tenenholz Re: Importing 'Excel' Files
May 23, 2011; 22:24
Drew Tenenholz
Re: Importing 'Excel' Files
May 24
Ed Bullock Re: Importing 'Excel' Files
May 24, 2011; 09:21
Ed Bullock
Re: Importing 'Excel' Files
May 24
Ed Bullock Re: Importing 'Excel' Files
May 24, 2011; 09:58
Ed Bullock
Re: Importing 'Excel' Files
May 24
Ed Bullock Re: Importing 'Excel' Files
May 24, 2011; 13:33
Ed Bullock
Re: Importing 'Excel' Files
May 24
Jonathan Fletcher Re: Importing 'Excel' Files
May 24, 2011; 09:00
Jonathan Fletcher
Re: Importing 'Excel' Files
May 24
Ed Bullock Re: Importing 'Excel' Files
May 24, 2011; 14:04
Ed Bullock
Re: Importing 'Excel' Files
May 24
Jonathan Fletcher Re: Importing 'Excel' Files
May 24, 2011; 09:23
Jonathan Fletcher
Re: Importing 'Excel' Files
May 24
Ed Bullock Re: Importing 'Excel' Files
May 24, 2011; 14:43
Ed Bullock
Re: Importing 'Excel' Files
May 24
Jonathan Fletcher Re: Importing 'Excel' Files
May 24, 2011; 10:02
Jonathan Fletcher
Re: Importing 'Excel' Files