Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Memo Fields |
Tue, Nov 3 2009 2:35 PM | Permanent Link |
"Sean McDermott" | DBISAM latest
It seems I am the neediest of the DBISAM users these days, sorry about that! Project almost done. I need to offer the ability to export tables and I have done this many times before but the latest tables I use have many memo fields. How do I handle these or how does anyone typically handle these? They just contain text so are really useful for any analysis but... Blob to stream? Thoughts always greatly appreciated, Sean |
Wed, Nov 4 2009 3:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sean
Depends on where and why you're exporting them, but I would have thought give DBISAM's inbuilt table.ExportTable a chance first. Roy Lambert |
Wed, Nov 4 2009 8:22 AM | Permanent Link |
"Sean McDermott" | I export to a csv for use with Excel. A test export with DBSYS ignores memo
fields (unless it puts them somewhere I am not aware of). If I dbl-click the memo field from with DBSYS and use the internal export button then I can see the contents. I will explore some more before, thanks, Sean > Sean > > > Depends on where and why you're exporting them, but I would have thought > give DBISAM's inbuilt table.ExportTable a chance first. > > Roy Lambert > |
Wed, Nov 4 2009 8:53 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sean
csv and memo fields is best described as "not nice". Before you progress to much I'd create an excel spreadsheet holding the data as you think it should look and then save as csv. You'll probably end up having to roll your own. However, a much better solution but SMExport (I have SMImport) from Scalabium or flexcel from TMS and it will much simplify your life. Either are reasonable value (TMS €75, Scalabium €50), but I'd recommend SMExport because for the price you get a load of other formats and my view is that Mike's support is better than TMS's. Roy Lambert |
Wed, Nov 4 2009 10:45 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sean,
<< I export to a csv for use with Excel. A test export with DBSYS ignores memo fields (unless it puts them somewhere I am not aware of). If I dbl-click the memo field from with DBSYS and use the internal export button then I can see the contents. >> Yes, DBISAM does not export memo fields so as to not confuse other import programs with embedded CRLF pairs from the memo fields. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Nov 4 2009 10:56 AM | Permanent Link |
"Sean McDermott" | Thanks Gents, I will also check out SMexport. Cheers, Sean
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:21CB1A27-F2A8-41A4-8FD6-411C91F3615F@news.elevatesoft.com... > Sean, > > << I export to a csv for use with Excel. A test export with DBSYS ignores > memo fields (unless it puts them somewhere I am not aware of). If I > dbl-click the memo field from with DBSYS and use the internal export > button then I can see the contents. >> > > Yes, DBISAM does not export memo fields so as to not confuse other import > programs with embedded CRLF pairs from the memo fields. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |