Personally I really like Open Office 3.0 except for 1 thing...if you use Outlook Express for email, no spell checker for your emails. ----- Original Message ----- From: John Engwer To: RBASE-L Mailing List Sent: Monday, August 24, 2009 12:01 PM Subject: [RBASE-L] - Re: Loading data from XLSX spreadsheets
Paul, Good idea, I will give that a try. John From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, August 24, 2009 10:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Loading data from XLSX spreadsheets 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 ------------------------------------------------------------------------------ From: "John Engwer" Date: Mon, 24 Aug 2009 10:44:17 -0400 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
