469,621 Members | 1,806 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Plez help quick - people waiting - IMPORT problem with A2K-Excel

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

Nov 12 '05 #1
1 2817
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Ron Adam | last post: by
5 posts views Thread by ndn_24_7 | last post: by
3 posts views Thread by Terry Bell | last post: by
13 posts views Thread by (Pete Cresswell) | last post: by
2 posts views Thread by Salad | last post: by
55 posts views Thread by Steven Nagy | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.