Sliphorn
Level 1 (14 points)
Photos for Mac

Q: Help needed in opening AW database in Excel

My wife has a massive AW database doc that needs to go to Excel for Windows but it does not seem to be working to make the move.  I saved it as an ASCII doc but it did not work.  Is this supposed to work?  Also, if I buy Excel for Mac, will this do any good?  Thanks.

iMac, Mac OS X (10.6.8)

Posted on Mar 18, 2012 3:09 PM

by Roger Wilmut1,Solvedanswer
Roger Wilmut1 Roger Wilmut1
Level 9 (78,562 points)
iTunes
A:

Yes, exporting as ASCII should work; the resultant file is tab-separated values and Excel may be set to look for comma-separated values: there may be a setting to change this when you import. Also you might need to change the extension from .txt to something else (.tab for example): this is something you would have to check in Excel's documentation.

Posted on Mar 18, 2012 3:54 PM

Close
Sliphorn

Q: Help needed in opening AW database in Excel

  • All replies
  • Helpful answers

  • by Roger Wilmut1,Solvedanswer

    Roger Wilmut1 Roger Wilmut1 Mar 18, 2012 3:54 PM in response to Sliphorn
    Level 9 (78,562 points)
    iTunes
    Mar 18, 2012 3:54 PM in response to Sliphorn

    Yes, exporting as ASCII should work; the resultant file is tab-separated values and Excel may be set to look for comma-separated values: there may be a setting to change this when you import. Also you might need to change the extension from .txt to something else (.tab for example): this is something you would have to check in Excel's documentation.