Re: [PCTECH] Another Excel/CA ?

["John Ross" <jross-ml@xxxxxxxxxxxxxxx>]

>From my vast experience (1 Spreadsheet) and not using Client access but 
>SQL2XLS 
(http://www.mcpressonline.com/mc?1@xxxxxxxxxxxxxxxxx@.6ae8269f ) 
(And a modified version to import to DB2) what I found was is was exported as 
one type of
field (character or numeric can not remember which) but the fields the user 
keyed over
came back as the opposite. It looked the same when Excel was displaying it. I 
just
changed my program to handle the difference. But I assume what you will have to 
do is
click on the row and format the cell that should make them all the same.

John Ross
IBM Certified Specialist AS/400 RPG IV Programmer

Fri, 21 May 2004 11:22:53 -0400
 
> Have an Excel spreadsheet, trying to us CA to create/upload to AS/400.  When
> it goes to scan the file it gives me an error saying scan operation found
> data mismatch at row 2 column 8.  Data in each column must all be of same
> data type.  In looking at sheet they are all numbers even row 2??
>  
> I do this all the time with no problem.
>  
> Any clues??