Differences

This shows you the differences between two versions of the page.

--- training:excel_import_leading_zeroes_2016 [2018/01/23 16:43 (6 years ago)] – created sjackson
+++ training:excel_import_leading_zeroes_2016 [2018/01/23 16:44 (6 years ago)] – sjackson
@@ Line 3: / Line 3: @@
 For those of you who have attempted to data load a CSV into the latest version of Excel with the Data Menu > Get Data From Text/CSV, you will have seen a new data importer that looks more like one might see inside of Microsoft Query.
 {{:training:excel:new_excel_wizard_1.jpg?nolink|}}
-{{:training:excel:new_excel_wizard_2.jpg?nolink|}}
@@ Line 10: / Line 9: @@
 The second method presented is to change from ‘auto-determine’ to ‘manually determine’.  It still not work even when you tell it to treat a column as a Text column because if it finds a double-quote in a description line (as an inch symbol), then 50 lines later if it finds another double-quote, it flat-out drops everything between the two double-quote appearances.  Or, it will attempt to stuff the 50 lines into a single Excel cell.  Loading something like a Polaris Price file is disastrous as thousands of lines are dropped out of the file.
+{{:training:excel:new_excel_wizard_2.jpg?nolink|}}
 The only method that works is to use Excel’s Legacy Data Load.