... points: 1. I prefer adopting the sql approach than using ADOX. 2. We need to be aware of the limitations of creating Excel sheets using ADO. a) Whatever length we specify, all character columns are VarChar(255) b) Whatever numeric datatype, like int, numeric(w,d), etc we specify the columns ...