The Member
Registered User.
- Local time
- Today, 00:50
- Joined
- Nov 2, 2001
- Messages
- 21
Hello all you wonderful people, I have got a issue that would need your help:
I am working on a database where it is to export a query to Excel on press of a button in a form. The fields to be exported consists of anything from Number to text to memo.
I have been testing the exportation function all seems fine but it seems that the memo field could at max export 255 characters (including spaces, checked with Word count).
On the other hand, If I am not to use the automation process, I openned the table and copy the entire page and paste into excel as text would bring ALL the required impformation needed.
It is quite a paradox and I do not want my users to do it manually, I sure there is a way around it, can anyone help??
Many thanks.
I am working on a database where it is to export a query to Excel on press of a button in a form. The fields to be exported consists of anything from Number to text to memo.
I have been testing the exportation function all seems fine but it seems that the memo field could at max export 255 characters (including spaces, checked with Word count).
On the other hand, If I am not to use the automation process, I openned the table and copy the entire page and paste into excel as text would bring ALL the required impformation needed.
It is quite a paradox and I do not want my users to do it manually, I sure there is a way around it, can anyone help??
Many thanks.
