[AccessD] OT Excel

[Stuart McLachlan]

i Just ran into the same problem last week.   

A client prints cheques for banks from a batch list provided by the bank.   I parse the batch 
list and the resultant data is used for producing the cheques, delivery slips, invoicing etc.

Suddenly the bank started producing Excel v2 files instead of the previous Tab delimited files 
(apparently they had a change of staff and the new person didn't see any problem with 
changing the way they produced the list from their system :(

We finally got them to produce new Tab delimited files.

To answer your question, it's tricky:

Here's C++ source to do it:
https://support.microsoft.com/en-us/kb/225029

and here's some other relevant info:
http://stackoverflow.com/questions/514847/how-to-identify-whether-an-excel-file-conforms-to
-excel-95-or-excel-97-specifica

On 5 May 2016 at 12:23, Martin Reid wrote:

> As a last resort
> 
> We export 2 feels from our Oracle student system and import them into
> CRM. 
> 
> Our code tells us the files are Excel 1996 and we need a later
> version. Of course our Oracle people tell us they are not 1996.
> 
> Is there anything that can with 100% accuracy identify the correct
> version of the source files in terms of Excel version?
> 
> Martin
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>