Skip navigation

Exporting a database as text

545 Views 4 Replies Latest reply: Dec 9, 2012 5:14 PM by werdup RSS
werdup Level 1 Level 1 (0 points)
Currently Being Moderated
Dec 4, 2012 4:10 PM

When I export a database from Appleworks as a text file then import it into Excel there are hundreds of entries missing. I need a CSV file to import it into Bento.


I have found that opening the file in a text editor and looking at the invisibles there are some entries where a tab and return are outside the margins of the document. I'm not sure what causes this or if this is the problem.


Any ideas why the complete file isn't being imported?



Mac mini, Mac OS X (10.6.8)
  • Peggy Level 8 Level 8 (38,085 points)
    Currently Being Moderated
    Dec 4, 2012 4:37 PM (in response to werdup)

    The last I checked since I don't use Bento, Bento can import tab-delimited files which is what AppleWorks exports. I think that was added way back with Bento 2. No need to use Excel or Numbers in between although I would probably copy & paste the contents of the AppleWorks database from list view into an AppleWorks spreadsheet, save that & then open it in Numbers. That is what I did with my AppleWorks databases.


    Here is a link to Filemaker's info on Bento & AppleWorks.



  • Peggy Level 8 Level 8 (38,085 points)
    Currently Being Moderated
    Dec 4, 2012 8:12 PM (in response to werdup)

    I would try manipulating the file in AppleWorks before exporting. Try changing the date to a format you can import in the AW DB. Also, try exporting as text from an AW SS. And, instead of using Excel, try opening the .txt file in TextEdit.


    I don't use Bento although I did buy the iPad version to try. So I'm just trying to give you some ideas.




More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.