in your connection string, set the Extended Properties to contain IMEX=1, for example, see
http://www.connectionstrings.com/"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
http://www.connectionstrings.com/"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
则可以通过以下设置来决定
Selection.NumberFormatLocal = "@" (VBA语法)其中"@"表示将单元格设为文本格式。