3 ms·
I use Java RMI to connect AIX to W2K3 running a service that uses Jacob COM to call Excel. It reads a CSV file off a Samba share on the AIX box and saves back a
by ourmandave 10y ago
I use Java RMI to connect AIX to W2K3 running a service that uses Jacob COM to call Excel. It reads a CSV file off a Samba share on the AIX box and saves back an XLS.
The lock file is on the AIX side because Win files aren't atomic.
It's a bit Rube Goldberg-ish and has low traffic, but it's rock solid.
- taspeotis 10y agoThat seems ... unnecessary. CSV and XLS parsing are built into Windows. https://www.connectionstrings.com/microsoft-jet-ole-db-4-0/standard-excel/ https://www.connectionstrings.com/microsoft-jet-ole-db-4-0/s... https://www.connectionstrings.com/microsoft-text-odbc-driver/standard/ https://www.connectionstrings.com/microsoft-text-odbc-driver...