Announcement

Collapse
No announcement yet.

How do you save a excel xls file to...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How do you save a excel xls file to...

    Hi all
    How do you save a excel xls file to a comma separated txt file (each product need to be on a separate row.

    I have fixed the stocktake file EPOS corrupted for me (!) and I now need to save it in the correct and only way EPEOS will read it.

    If we had the chance to export and import files (common extensions) we would have 50% of the problems we currently have with this version of EPOS.

    Thanks

    PS anyone has a 'free' file converter? A visual basic one - ready made!
    Ciao
    actinico

    ps sorry for any 'typing' errors or mistaks
    ;-]

    #2
    In Excel choose Save As - then select csv comma separated values from the list of choices.
    Bill
    www.egyptianwonders.co.uk
    Text directoryWorldwide Actinic(TM) shops
    BC Ness Solutions Support services, custom software
    Registered Microsoft™ Partner (ISV)
    VoIP UK: 0131 208 0605
    Located: Alexandria, EGYPT

    Comment


      #3
      Hi
      Yes, I do know that.

      Unfortunately EPOS will not read it within the stocktake window.

      That is why I was asking and if I find out I will post it.

      If not I can close our shop and go to work for somebody else ;o]


      LATEST: thanks to your input it came to me how to do it!
      The only thing I did not try!

      I have opened the csv file I saved yesterday after I fixed all corrupted records using notepad and saved it as txt file.
      Then recalled it with EPOS and although EPOS keeps saying ERROR _ IMPORTING STOCKTAKE FILE and then I clicked OK and got a window with 'Microsoft Access' saying '0' ,
      it actually loads it fine!

      For now it seems fine!
      Ciao
      actinico

      ps sorry for any 'typing' errors or mistaks
      ;-]

      Comment

      Working...
      X