Importing excel sheets

[Gennady Vayl]

Hi,
Let say we have an excel sheet with column 1 is a number column say 1
to 100.
The second column has text.

| A | B
1 | ID | Description
2 | 1 | Text1
3 | 2 | Text2
4 | 3 | Text3
| | Text4
| | Text5
| | Text6
| | Text7
5 | 4 | Text8

As you can see Row 4 has Text3 to Text7 in one cell. When I import this
in access since in access 255 is max cell text limit, I get some of the
contents truncated. So I would get Text3,4,5 and not 6 and 7. Is there
anything I can do to maybe seperate the above in Excell or Access so
that I could get all the texts? May be so it would look like this in
Excell?

| A | B
1 | ID | Description
2 | 1 | Text1
3 | 2 | Text2
4 | 3 | Text3
5 | | Text4
6 | | Text5
7 | | Text6
8 | | Text7
9 | 4 | Text8

Thanks

[pietlinden]

Gennady Vayl wrote:

Hi,
Let say we have an excel sheet with column 1 is a number column say 1
to 100.
The second column has text.

| A | B
1 | ID | Description
2 | 1 | Text1
3 | 2 | Text2
4 | 3 | Text3
| | Text4
| | Text5
| | Text6
| | Text7
5 | 4 | Text8

As you can see Row 4 has Text3 to Text7 in one cell. When I import this in access since in access 255 is max cell text limit, I get some of the contents truncated. So I would get Text3,4,5 and not 6 and 7. Is there anything I can do to maybe seperate the above in Excell or Access so
that I could get all the texts? May be so it would look like this in
Excell?

| A | B
1 | ID | Description
2 | 1 | Text1
3 | 2 | Text2
4 | 3 | Text3
5 | | Text4
6 | | Text5
7 | | Text6
8 | | Text7
9 | 4 | Text8

Thanks

No idea.... use ADO or DAO and read a cell at a time? If the length of
the cell contents is over 255, then break the line into chunks of 255
characters, and write each chunk to a new record?