What would happen if you used Open Office? Instead. I wonder if you could skip a step. MS vs GNU. Sun. Or who they are today.
Paul Sent from my Verizon Wireless BlackBerry -----Original Message----- From: "John Engwer" <[email protected]> Date: Mon, 24 Aug 2009 10:44:17 To: RBASE-L Mailing List<[email protected]> Subject: [RBASE-L] - Loading data from XLSX spreadsheets For those of you that load data with text fields that are numerals, from XLSX spreadsheets, beware of the following. I receive product information from many manufacturers that contain product UPC numbers. These UPC codes are usually 12 digits long (text) and they usually send the data in an XLS or XLSX format. When I receive the data, I save the XLS spreadsheet as a CSV file and then load it into my database. This worked well for many years. Now I am finding that that the UPC data does not always save properly when you go from XLSX to CSV (all other fields in the records are OK). The UPC is correct in the original XLSX file but a few UPCs in the CSV file do not convert properly. A few meaning 12 out of 20,000 records in my most recent file. The work around that I now use is to save the XLSX file to the 2003 XLS format, then save the XLS file as CSV. That works correctly every time. John
