Assistance Exporting A Query Over 255 Characters

[NewYorkFashionToGo]

I have created a query that when the (memo)text is put together creates a query that goes over the 255 character limit. Everything I did is visible inside the query, and it functions just fine, I would like to export it now and can not figure out how to get all the information to export. I tried linking to an excel sheet I tried exporting, I tried appending to table, create a new table. The data gets cut off. Is there a way around this?
Thanks in Advance

 

[CautionMP]

NewYorkFashionToGo,
Yes, write your own routine to move the data out of the database. The link below should get you moving in the right direction.

[tab]thread705-1260935 : Export A Dynamic Query TO Excel

Hope this helps,
CMP

P.S. Beware of the [tt]CopyFromRecordset[/tt] method mentioned by PHV, I believe that it will trucate your memo field to 255 characters.

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[NewYorkFashionToGo]

Thanks for your reply, I tried many different ways to achieve this from the thread you remommended, no success in achieving the results that I would like to have doing it that way. I didnt try the long code that you posted on that thread, I am rather new to all of this and simply do not understand what to do with the code, just yet. On the other codes I have created macros and then converted to modules and changed the code accordingly to what that post had said. It was very close to what I did have set, But still no success doing it that way, Still no success it tructuated the fields at 255 characters.

I did find another thread that helped solved the problem, thread181-1016518 . I now can take that information and the information you supplied and make something of it. I do appreciate you taking the time to write and posting and helping, Its Much appreciated. Thanks for taking the time to help a novice.