Comments by Nancy3595 (Top 1 by date)

I'd rather not use third-party software. I read the article recommended by William Winner and it looked promising. This article shows examples on how to create spreadsheets, however, and I am trying to read a spreadsheet with inconsistent data types. I looked for a similar article for reading spreadsheets and didn't find one. I am using a workaround for now where I will change the format of the columns that are supposed to be 'number' to 'text' before reading it. This way, all the numbers are read as text and my program converts them. From other articles, it appears using OLEDB will always read a null when a cell is formatted incorrectly. If anyone can tell me how to read an excel spreadsheet without using OLEDB, I'd appreciate it. Meanwhile, thanks to everyone who offered help.