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 several clients to change to FMpro or Access. Excel has some weird Microsoft settings, Access is more robust.Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites Sean an x-mass card from http://www.elive.ie/ecard/postcard.tpl **************************************************************** Associated Messages, from the most recent to the oldest:

    
  1. Re: Exporting from Excel (Pat McCormick 1998)
  2. Re: Exporting from Excel (Mícheál O Sé 1998)
  3. Exporting from Excel (josh@pop-art.com 1998)
>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 several clients to change to FMpro or Access. Excel has some weird Microsoft settings, Access is more robust.Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites Sean 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)