Encounter with an error while uploading a file in ibm db2

Asked By eri kviars 10 points N/A Posted on - 01/30/2013

Hi,

I am facing an error while uploading the Excel file in IBM DB2. The error indicates the mismatch of data at column. I don’t know why I am encountering this error. Is it possible to upload data stored in different formats? Any ideas and suggestions are welcomed to resolve this issue of uploading a file in ibm db2.  I am Waiting for a quick reply.

• Status: Open
• Question Views: 820
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB2

Answered By Williamson Mellisa 5 points N/A #181493

Encounter with an error while uploading a file in ibm db2

Hello,

Try with this few solutions maybe some of them will help you.

Add to the empty cells in Excel, Text format then type the numerical data. If your numeric data is typed in the cells then add the text format to the cells. Select each cell separately and press F12 key and then click on Enter key for typing data again.

With an entry line, select the cells with numeric data and apply the single quote to the each cell. Alternative, you can use concatenate formula for join a column that have single quota in each row with a column with mixture of numeric and character data. For the syntax of Concatenate formula you can find on the internet.

Also you should do the next thing: to save the excel file as Tab Delimited text and then exit the Excel document. Now open the text Tab Delimited files in Excel again and choose Delimited. From the wizard screen select Tab and set every data type for each column. This will open the file in Excel so it can be saved with .xls extension. 

Regards,

Williamson Mellisa

About Williamson Mellisa

Questions
2

Answers
201

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/03/2013
• Question Category: DB2