Copy limitations

[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?

 

[Frank Kabel]

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

 

[Ron de Bruin]

Hi Steve

If you copy a sheet you have this problem

http://support.microsoft.com/default.aspx?scid=kb;en-us;213548&Product=xlw2K
XL2000: "255 Characters in Cell" Error When Copying Worksheet

You can copy all cells to a empty sheet as a workaround

 

[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.)

 

[Jamie Collins]

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

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.

--