|
|
 |
| |
|
| |
When I import a Microsoft® Excel file, only some values print fine and others print zeros. How can I prevent this from happening? |
|
| |
Excel is a spreadsheet application, and each cell contains formatting characters, formulas, and other encoded information not visible from inside the application. Excel sometimes inserts ' before each numeric value and " in front of the alpha numeric values. When you use ODBC to link to your data these characters can be interpreted as delimiters.
In order to remove these unwanted formatting characters, do the following in Excel:- Open your spreadsheet. Select File > Save as
- In the Save as Type pulldown, select the CSV (comma delimited).csv option.
You will be prompted with a warning informing you that saving the file in this format may be incompatible with some features of a .xls file. Click Yes to continue and save your file in the .csv format.
- Create a new Blank Workbook. Click the area above between column A and Row 1 to hilight the entire sheet. Select Format > Cells and select the text option. Clik OK.
- Select cell A1. Select Data > Import External Data > Import Data.
- Browse to the .csv file you saved in step 2. Highlight the .csv file click Open.
- The Import Wizard will launch. Select Delimited and click Next.
- Check the 'comma' checkbox in the delimiters section of the wizard and select None for the text qualifier. Click Next.
- Highlight any columns that are dropping values in the Data Preview and select the 'Text' radio button in the Column Data Format box (You may need to repeat this step for more than one of your fields).
- Click Finish and click OK.
How can I import my Microsoft® Excel file into LABEL MATRIX's internal database?
|
|
|
|
