eksport forspørgelse korter teksten af

SELECT Left(Thefield, 50) FROM YourTable

men den skal jo tage hele notat-feltet med, hvis jeg skrive 50 tager den vel kun 50 med .!!!

kan jeg bare skrive 500 det sker der vel ikke noget , når man så flytter den over i excel

det virker ikke terry jeg skal have hele notat-feltet med over i excel

I would imagine that there is a max length of 255 chararacters when exporting!
That could be A LOT of data your exporting there!

Try exporting to  a text field to see what you get out, I still doubt that it will export the whole memo field?

hvad gør jeg så , bruge hele teksten

hvad gør jeg så , jeg skal bruge hele teksten!!!!!

Have you tried exporting to a text file? If so, do you hav ethe same problem there? Am I right in saying that you only get the first 255 characters?
How many characters MAX do you expect in your MEMO.
Well all that I can think of is split it up into further columns!
You could use the MID function to do this.

WHY do you need to export ALL of the MEMO field? They can hold a hell of a lot of data, do people really need top see so much data in Excell ?

ja det er en masse katalog beskrivelser og teksten kan let blive meget lang .

Hvordan skal du bruge dataene i Excel?

som tekst det skal bruges som katalog-beskrivelse

juks> how many chararacters do you need for a "katalog-beskrivelse"

ligeså meget som i et notat-felt.

juks> that could thousands of characters!

ja , hvorfor kan jeg ikke tage det med i en forspørgelse. Hvordan skal jeg ellers dele det op.

you could use the mid() function to split it up but as you dont know how many characters to expect then you dont know how many extra columns you will have!

HAVE you tried exporting to a text file to see how many characters you get there?

det hjælper heller ikke

so you see, there is a limit to exporting so many characters!

You WILL have to split your memo field up! So I suggest that you take for example 10 columns at 255 characters in each using MID()
Another way is to write each record to a file, but STILL a memo field can hold a hell of a lot of data!

Jeg tror ikke det er Access's skyld at eksporten ikke virker, da excel garanteret har en begrænsning af karaterer i et felt, så der skal nok bruges et andet program til katalog beskrivelserne.

nope ellers ville det jo virker som terry sagde i en txt fil

juks>I just find it hard to believe that it IS necessary to have SO MUCH data in one field! and Excel isnt really designed for this in the first place thats what databases are for!
Do you have access to MS SQL Server too?  If so you could use DTS to export from Access but I just DO NOT think that Excel can accept so much in one field!

terry , så ville man også kunne eksportere det i en txt-fil ik ?
nej jeg har ikke sql, desværre, men det ville jo heller ikke hjælpe så meget da jeg ikke kan se mere 255 i en forspørgelse ?

not sure which quesion this is in answer to "så ville man også kunne eksportere det i en txt-fil ik ?" !
Juks>I am sorry to say that I dont think your going to get much closer to an answer than those given already

terry - denne begrænsning (255chr) har jeg hørt er rettet i access XP ...

not sure, I will have to look at that!

Problemet er det samme i Access 2002 (XP)