×
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.
SQL files should make no difference. Perhaps you need to do something in
your excel to denote those "numbers" as character. Maybe change the type
to text or something.
I tried a DDS file I was getting CWBTF0105 - error ... row 0... while
performing data conversion
My sample excel data had
123
45678
123
1
Then I added an excel formula
=text(a1,"00000")
Which created another column as
00123
45678
000123
00001
Which I then copied and pasted special as Values.
That uploaded just fine.
DDS from file.
R TEXTNBRSR
MYCHAR 5A
Deleted the file
Recreated it with
CREATE TABLE ROB.TEXTNBRS (MYCHAR CHAR (5 ))
RCDFMT TEXTNBRSR
Deleted the column in Excel
Did a Format, cells, text
Didn't mess with the formula or pasting...
Just rekeyed
123
45678
123
1
Ran the exact same transfer request and the sucker worked.
Rob Berendt
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.
midrange.com
