Richard Holliingsworth <wi*********************@boeing.com> wrote in message news:<HK********@news.boeing.com>...
Hello:
Thanks for your quick response.
I'm trying to import a new Excel file into an A2K table and it's
truncating the data. One of the Excel columns is a text field that can
be up to 2000 characters. When I import it into A2K, that field is
truncated. If I try to inport the file into an EXISTING table that I
define myself where that field is a MEMO field, the import crashes.
Can someone please tell me the best way to import Excel tables with
large text fileds into A2K. (or SQL Server 7). Please email me if you
can cause I have developers waiting on this table........
Thanks,
Richard H
Richard,
A not so quick response:
I made some tests with this, but I had no problem importing text-data
of 26k per cell in a prredefined table.
However when I tried to make a link to the Excel-data I also got
truncation, ( to some 256 characters, I did not count them)
In that case I found that a format-attribute was the cause of this
result. Removing a default generated "@" format specifier resulted in
a full visibility of all memo data.
If this is not the cause in your case I would look for clues in the
installed versions (especially to the ISAM-drivers for Excel-data) or
perhaps the contents although both should be Unicode when not from an
older version of Excel. When importing text-data with a lot of
CR/LF's, tabs and other types of non-character ascii from a report in
ASCII I often had similar problems during import including hanging.
These were non-Unicode import-files. May be in that case just saving
in the last fashion of Excel, closing and reopening of the speadsheets
could help ..
Marc