811 votes145 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
John [MS XL]
An error occurred while saving the commentAnonymous commented
When I Import Excell table into Access I got message that not all records could be imported due to data format mismatch. To be more precise - Access assumes that "" is not a number and generates an error and a ImportErrors table with about 23,000 records (from 3 Excell fields). Also it imports 10,000 records even though most of the records i Excell contain formulas which result in "" and I don't want those records to be imported into Access.Anonymous supported this idea ·