Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from excel with cells 256 chars in
There must be a way to export data sheets that have cells with more than 256
chars of text in. Any leads, suggestions? Somebody must have found a way since I do not believe I am the only person on the planet to have hit this "feature" in excel. Got a large sheet that had been used forcollecting textual comments.. Need to get that to access so that it can be handled sensibly. But excel 2003 export refuses to cooperate. Same with access import.. Thanks Juha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from excel with cells 256 chars in
Try with defining your Access fields with the "memo" type.
HTH Daniel There must be a way to export data sheets that have cells with more than 256 chars of text in. Any leads, suggestions? Somebody must have found a way since I do not believe I am the only person on the planet to have hit this "feature" in excel. Got a large sheet that had been used forcollecting textual comments.. Need to get that to access so that it can be handled sensibly. But excel 2003 export refuses to cooperate. Same with access import.. Thanks Juha |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from excel with cells 256 chars in
I don't speak the Access, but Debra Dalgleish once posted a suggestion to
transfer data between access and excel by using Access's VBA via "DoCmd.TransferSpreadsheet". I don't speak the Access, but maybe it'll work for you. juhariis wrote: There must be a way to export data sheets that have cells with more than 256 chars of text in. Any leads, suggestions? Somebody must have found a way since I do not believe I am the only person on the planet to have hit this "feature" in excel. Got a large sheet that had been used forcollecting textual comments.. Need to get that to access so that it can be handled sensibly. But excel 2003 export refuses to cooperate. Same with access import.. Thanks Juha -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyone notice excel search within cell limited to first 1024 chars | Excel Discussion (Misc queries) | |||
export/copy excel cells to Word | Excel Discussion (Misc queries) | |||
Can I export cells from Excel into a PhotoShop layer? | Excel Discussion (Misc queries) | |||
Excel Nonprinting Chars Utility | Excel Discussion (Misc queries) | |||
geomean ignoring blank cells and chars | Excel Worksheet Functions |