Copy limitations

S

Steve Rouse

When I transfer data from Access to Excel it will only
copy 250 characters. When I copy an Excel sheet it will
only copy 250 characters. Can this number be increased?
 
F

Frank Kabel

Hi
the limit should be 255 :)
Not much chance to do anything against it AFAIK
(restriction of the database driver)
 
D

Dave Peterson

Debra Dalgleish has posted this a couple of times.

I don't speak the Access, but it looks like you can send longer strings from
Access to Excel.

http://groups.google.com/[email protected]

And when I copy a sheet with those long strings, I do the copy twice.

The first copy is the whole sheet (edit|move or copy sheet).
this gets all the formatting/page setup, etc.

Then I come back and copy the cells (ctrl-A (2 times in xl2003)
and Edit|copy
then Edit|paste

(That was Ron's suggestion.)
 
J

Jamie Collins

Frank Kabel said:
the limit should be 255 :)
Not much chance to do anything against it AFAIK
(restriction of the database driver)
Click to expand...

How do you know? The OP didn't say how they were transferring the
data, which driver they are using, which version of Jet, which version
of Excel, etc.

Using the MS OLEDB JET 4.0 driver and a SELECT..INTO query to create
an Excel8 workbook, the values aren't truncated. To demo:

CREATE TABLE FranksTable
(MyMemoColumn MEMO)
;

INSERT INTO FranksTable
(MyMemoColumn)
VALUES ('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890')
;

SELECT
MyMemoColumn
INTO
[Excel 8.0;HDR=Yes;Database=C:\Frank.xls;].Sheet1
FROM
FranksTable
;

SELECT
LEN(MyMemoColumn) AS length_exported
FROM
[Excel 8.0;HDR=Yes;Database=C:\Frank.xls;].Sheet1
;

I get length_exported = 300.

Jamie.

--
 
Top