Re: Exporting from Excel
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21837
interpreted = N
texte = >I remember seeing some posts on this in the past but I can not find them in>the talk list.>>Anyway, I am having a terrible time exporting a tab separated text file>from excel 97. I get weird line breaks and quotations. Does anyone have>any advice for getting a clean export?Excel has a problem with field sizes over 256 char, We advised severalclients to change to FMpro or Access. Excel has some weird Microsoftsettings, Access is more robust.Regards,****************************************************************Micheal O Sewww.elive.ie Internet Hosting Servicemicheal@elive.ie Database powered websitesSean an x-mass card from http://www.elive.ie/ecard/postcard.tpl****************************************************************
Associated Messages, from the most recent to the oldest:
>I remember seeing some posts on this in the past but I can not find them in>the
Talk List.>>Anyway, I am having a terrible time exporting a tab separated text file>from excel 97. I get weird line breaks and quotations. Does anyone have>any advice for getting a clean export?Excel has a problem with field sizes over 256 char, We advised severalclients to change to FMpro or Access. Excel has some weird Microsoftsettings, Access is more robust.Regards,****************************************************************Micheal O Sewww.elive.ie Internet Hosting Servicemicheal@elive.ie Database powered websitesSean an x-mass card from http://www.elive.ie/ecard/postcard.tpl****************************************************************
Mícheál O Sé
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
PROBLEM (1997)
HUGE DATABASES (1998)
passing cart value (2003)
Trouble with formula.db + more explanation (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Problems appending to database (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
[WebDNA] Write uploaded file with same name (2020)
Bug? (1997)
Can I invoke an ssi plugin from within a webcat page (1997)
Arrays (2000)
Bug - 4.5 (2002)
View Source from cache (1997)
WebCatalog on SUSE-Linux 6.3... please help! (2000)
tcp connect includes (1999)
Updating a database once per day - An example (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
emailer w/F2 (1997)
[WebDNA] Recurring Orders (2012)
Reserved words - Enhancement request (2000)