Using ADO and ASP I managed to upgrade a Excel Sheet.
When I opened the Sheet I noticed that some Columns are filled with a line of #
Does anyone why is the cause of this, and how I can prevent it?
Because when I save the xls sheet to csv sheet, the lines of # end up in the sheet, and that is not what I would like to happen.
Thank you for the reply, but I allready solved the problem. Because the colomn was set to "text" type it displayed the ### because the string was to long. I solved the problem bij setting the colomn type to "general" instead.