Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Some columns values are null after converting an Excel worksheet into any of the supported database?

April 26, 2017columns converting database Excel null supported values worksheet

0

Posted

Some columns values are null after converting an Excel worksheet into any of the supported database?

1 Answer

0

Posted

Ans. This happens if the Excel Column contains intermixed data. If you have numeric values mixed with text values in the same column. Both the Jet and the ODBC Provider return the data of the majority type, but return NULL (empty) values for the minority data type. This is a known bug in the Microsoft Excel ODBC driver and OLE DB Provider. http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819 There is a simple solution for this.