I've searched this goup for an answer to this, there are many
discussions that come close but non that I can find that actually
addresses this particular problem.
I'm exporting queries to Excel. These queries have memo fields in them
Each memo field is trunkated, i.e cuts off after 255 characters.
Is there any way either via VBA or otherwise to get all my memo text to
export to Excel.
I note that there is no such limit when exporting to RTF, but I need
the Excel format.
Any help would be much appreciated, apologies if this has already been
discussed and answered. 8 13212
Does this article help:
Memo Field Truncated When Report Is Output to Excel
at: http://support.microsoft.com/default...b;en-us;208801
It suggests specifying a more recent Excel format.
If that doesn't help, does the query itself show more than 255 characters?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Taffman" <Da**********@g mail.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . I've searched this goup for an answer to this, there are many discussions that come close but non that I can find that actually addresses this particular problem.
I'm exporting queries to Excel. These queries have memo fields in them Each memo field is trunkated, i.e cuts off after 255 characters.
Is there any way either via VBA or otherwise to get all my memo text to export to Excel. I note that there is no such limit when exporting to RTF, but I need the Excel format.
Any help would be much appreciated, apologies if this has already been discussed and answered.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in
news:43******** **************@ per-qv1-newsreader-01.iinet.net.au : Does this article help: Memo Field Truncated When Report Is Output to Excel at: http://support.microsoft.com/default...b;en-us;208801 It suggests specifying a more recent Excel format.
If that doesn't help, does the query itself show more than 255 characters?
I ran onto this problem the other day exporting to tab-delimited
text (for import into a MySQL database on a website). I discovered
something new about saved export specs, that the column types are
there, but hidden, like with hidden columns in datasheets. By
default the export spec datasheet lists only If you put your mouse
cursor over the right-hand edge of the single field name column and
drag, you can open up the other columns (the ones you'd see in an
import spec). Actually, you have to put the mouse over to the right,
a bit away from the edge of the single column header. With fiddling
around like this, you can eventually see the data type column, and
you'll see that it's likely set to TEXT instead of to MEMO.
An esier way of fixing this is to do an export, then start an import
from what you've just exported. Load the saved export spec, and
you'll be able to see the data types more easily there (without
having to futz with datasheet column widths). Change the relevant
columns to memo and save the spec, and then the export spec should
work properly, as well.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton wrote: I ran onto this problem the other day exporting to tab-delimited text (for import into a MySQL database on a website). I discovered something new about saved export specs, that the column types are there, but hidden, like with hidden columns in datasheets. By default the export spec datasheet lists only If you put your mouse cursor over the right-hand edge of the single field name column and drag, you can open up the other columns (the ones you'd see in an import spec). Actually, you have to put the mouse over to the right, a bit away from the edge of the single column header. With fiddling around like this, you can eventually see the data type column, and you'll see that it's likely set to TEXT instead of to MEMO.
An esier way of fixing this is to do an export, then start an import from what you've just exported. Load the saved export spec, and you'll be able to see the data types more easily there (without having to futz with datasheet column widths). Change the relevant columns to memo and save the spec, and then the export spec should work properly, as well.
I am very keen to understand the suggestion that you outline above,
David, but I don't follow what you mean by an "export spec". Could you
please explain?
Thank you,
Oliver
oliverjames at mailinator dot com
In addition to what others have suggested, here are some things
to try:
Remove the DISTINCT keyword from the query (if a query is used)
Remove functions from Memo Field columns in query
{don't use Nz(MyMemo) or IIF() or any functions}
Remove Format property value from Memo field in Query
If it still truncates, remove Format property from all columns
Personally, I can't explain why any of these would help, but they do.
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com/datafast
"Taffman" <Da**********@g mail.com> wrote ... I've searched this goup for an answer to this, there are many discussions that come close but non that I can find that actually addresses this particular problem.
I'm exporting queries to Excel. These queries have memo fields in them Each memo field is trunkated, i.e cuts off after 255 characters.
Is there any way either via VBA or otherwise to get all my memo text to export to Excel. I note that there is no such limit when exporting to RTF, but I need the Excel format.
Any help would be much appreciated, apologies if this has already been discussed and answered.
Success!
I removed the functions from the memo field (as suggested by Danny)
AND
I specified the Excel format as 97-2002 (using the File Export menu
choice) (as suggested by Microsoft, referenced by Allen)
THEN
it did not truncate.
(I was not using the DISTINCT keyword or any format properties.)
However, I would still be interested to know more about the Export
specs that Mark referred to.
Cheers,
Oliver
Danny J. Lesandrini wrote: In addition to what others have suggested, here are some things to try:
Remove the DISTINCT keyword from the query (if a query is used) Remove functions from Memo Field columns in query {don't use Nz(MyMemo) or IIF() or any functions} Remove Format property value from Memo field in Query If it still truncates, remove Format property from all columns
Personally, I can't explain why any of these would help, but they do. -- Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com/datafast
"oliver james" <ol*********@ma ilinator.com> wrote in
news:11******** **************@ g47g2000cwa.goo glegroups.com: David W. Fenton wrote: I ran onto this problem the other day exporting to tab-delimited text (for import into a MySQL database on a website). I discovered something new about saved export specs, that the column types are there, but hidden, like with hidden columns in datasheets. By default the export spec datasheet lists only If you put your mouse cursor over the right-hand edge of the single field name column and drag, you can open up the other columns (the ones you'd see in an import spec). Actually, you have to put the mouse over to the right, a bit away from the edge of the single column header. With fiddling around like this, you can eventually see the data type column, and you'll see that it's likely set to TEXT instead of to MEMO.
An esier way of fixing this is to do an export, then start an import from what you've just exported. Load the saved export spec, and you'll be able to see the data types more easily there (without having to futz with datasheet column widths). Change the relevant columns to memo and save the spec, and then the export spec should work properly, as well.
I am very keen to understand the suggestion that you outline above, David, but I don't follow what you mean by an "export spec". Could you please explain?
Look it up in the Help file.
If you have problems after trying to work it ou on your own, then
post back to the newsgroup.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
David W. Fenton wrote: I am very keen to understand the suggestion that you outline above, David, but I don't follow what you mean by an "export spec". Could you please explain?
Look it up in the Help file.
If you have problems after trying to work it ou on your own, then post back to the newsgroup.
-- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
I had tried to find it in the Help file, but had finally given up.
However your message gave me hope and I did eventually get there! I
never imagined, however, how convoluted it would be to run the Text
export wizard - shouldn't there be a direct option from a menu?!
Cheers,
Oliver
"oliver james" <ol*********@ma ilinator.com> wrote in
news:11******** **************@ g14g2000cwa.goo glegroups.com: David W. Fenton wrote:
> I am very keen to understand the suggestion that you outline > above, David, but I don't follow what you mean by an "export > spec". Could you please explain?
Look it up in the Help file.
If you have problems after trying to work it ou on your own, then post back to the newsgroup.
I had tried to find it in the Help file, but had finally given up. However your message gave me hope and I did eventually get there! I never imagined, however, how convoluted it would be to run the Text export wizard - shouldn't there be a direct option from a menu?!
It doesn't seem convoluted to me.
And, so far as I can see, there *is* a pretty direct method for
getting there, from the FILE menu.
I'm not sure how much more direct it could be.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: gevayl |
last post by:
Hi,
Is it possible to do memo text formating in ms access 2000? I mean like
underlining a portion of text in a memo field or a text field?
Thank you.
|
by: mail2atulmehta |
last post by:
Hi,
I do not know if this is right place for this, but i need some help. I
have a text file, whose values are seprated by a delimiter. I want to
open this file in excel, ( not import it) . I have written the driver
prg in c#. The code opens the file, but it is not writting the values
from text file into excel file. I can not figure out the...
|
by: Max Mayer |
last post by:
Hello everybody,
I have implemented a windows form in C# .NET to export data from a listbox
to Excel. I work on a Windows XP machine with Office 97 and .NET framework
1.1 SDK installed. I use Visual Studio .NET 2003, German version, Service
Pack 1. The Excel Export works fine on my developement machine, but I
cannot export data into Excel...
|
by: Max Mayer |
last post by:
Hello everybody,
I have implemented a windows form in C# .NET to export data from a listbox
to Excel. I work on a Windows XP machine with Office 97 and .NET framework
1.1 SDK installed. I use Visual Studio .NET 2003, German version, Service
Pack 1. The Excel Export works fine on my developement machine, but I
cannot export data into Excel...
|
by: arnab |
last post by:
Dear All,
I have a code which does Excel Export using ASP.NET Content disposition. The
whole code works fine and opens up a dialog box to open,save when i click on
the export button. If i save the file, its ok. But if i click on "Open" then
it opens in the same browser. Actually it should open in Microsoft Excel.
How to achive this ?...
| |
by: gokulin |
last post by:
Hi All,
I am writing an ASP.NET application in C# (an Application integrated and communicates with MS CRM) with Excel Export and Import options.
The user of the system exports data from the system as Excel spreadsheet, makes changes to spreadsheet and imports it into the system again.
My problem is: Export goes well. But when I try to...
|
by: Sergio E. |
last post by:
Hi, I'm looking for information about gridview's cell properties...
I've the following case: one gridview with alternatirg row style and
normalrowstyle, 3 o 4 custom styles that are applied to cells in the
row_databound event, and now I nedd to do a excel export of the gridview
exactly as is showed in the browser, but al the examples and...
|
by: Ned1966 |
last post by:
I want to automatically date stamp a memo/text box when i click a combo box. i know how to start the code bulider in the event properties of the combo box and get it to select the memo/text box i.e combo123.SetFocus and combo123.Value = today () but what i would like it to do is to go to the end of whatever text is already in the memo/text box,...
|
by: cdonham |
last post by:
When displaying a Memo Text field in a report using SQL Reporting Services the hidden Controls such as fonts margins, etc also show.
When doing the same task in Crystal Reports, I convert the Memo field to an RTF fild or HTML and that takes care fo the problem.
What is the syntax that I could use to convert to RTF?
Thanks for your...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |