× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I'm not sure about the VarChar() part, Loyd, but I had a similar problem with numeric data in the spreadsheet. Somewhere in the transfer process is a data definition section, in which you can specify the data type for each column. Setting the "numeric" column to a type of character worked for me.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of lgoodbar@xxxxxxxxxxxxxx
Sent: Thursday, July 24, 2008 2:03 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Excel file transfer with SQL files?

Can the Excel file transfer (upload) utility be used with SQL-defined
files?

There's some data I would like to upload from Excel into a SQL file but
am receiving errors.



Added column headings to the data matching the system column names.
Highlighted the data and column headings; they are in the same order as
the file. Ran the "Transfer data to iSeries" in Excel. Create new
request. Selected the option to Allow numeric data in character columns
to be converted to character data.



Receiving the error message "CWBTF0073 - The type of a column in the
spreadsheet selection does not match the corresponding column type in
the database file." It's too bad it doesn't specify which column is in
error, how do I find this?



The SQL table contains four columns, all are varchar(). I have "numbers"
in Excel that should be treated as character data (cost centers).



TIA,

Loyd



Loyd Goodbar

Business Systems

BorgWarner Shared Services

662-473-5713



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.