I am very new to Filemaker but after 1 months of intense tests I am able to create records, manage DBs, use scripts and many other nice things.
My problem: my company has some informations in a big ODS (which is the "excel" file of Libreofice/Openoffice) which I need to gather from my Filemaker application.
Example: I need that my Filemaker application goes to browse (i.e.) line 2345 and get the informatiosn on cells I,J,V
These infos will be assigned to three internal variables on a field of my Filemaker application.
Note: ODS does not mean CSV
What I can do guys ? The ODS file is updated daily, so my application needs to open it and do the above mentioned operations... Since I cannot use MS Excel (so XLS/XLSX), what would be the best solution ?
Thanks in advance,