See the keep_leading_zeros() section for a full discussion of this issue. For example: A Yes/No field displays -1 and 0 in Datasheet view after the import operation is completed. To fix this, after the import operation is complete, set the field’s Format property to Yes/No to display check boxes instead. Filehandles can also be useful if you want to stream an Excel file over a socket or if you want to store an Excel file in a scalar. Insert a new Excel worksheet, and name it Hosts. Number of columns The number of source columns cannot exceed 255, because Access does not support more than 255 fields in a table. Therefore to freeze the first row of a worksheet it is necessary to specify the split at row 2 (which is 1 as the zero-based index). This might lead you to think that you are using a 1 based index but this is not the case. For an Office 365 Click-to-Run installationWindows 8On the Start screen, type Control Panel.Click or tap Control Panel.Under Programs, click or tap Uninstall a program.Click or tap Microsoft Office 365, and then click or tap Change.Click or tap Online Repair, and then click or tap Repair.
Tutorial: Import Data into Excel, and Create a Data Model Excel
Скачать DOC: drg_18_um.doc