PDA

View Full Version : How to paste memo info into a spreadsheet?


phalsey
March 20th, 2003, 12:59 PM
O.K., I'm stupid.
I create a report and export it to Palm memo. It looks like gibberish, except for an occasional word or client name. How do I cut and paste this into a spreadsheet (Appleworks) so that I can bill with it?

Please, please help. I want to use AllTime for my time and billing.

Thanks,

Phil Halsey

splicer
March 28th, 2003, 09:04 AM
I don't have firsthand knowledge of AppleWorks, but I've never seen a spreadsheet that couldn't read comma-seperated text files. So here's how it *should* work.

Once you generate the report in AllTime, it becomes a memo. Synch the Palm and then the memo will appear in Palm Desktop. In Palm Desktop, select the memo and "export" (under the file menu on my system). Select "file type" as text, since the report is already in a comma-separated format. Save it somewhere you'll be able to find it, like the desktop or a special folder just for invoices.

Then go into your spreadsheet and you should be able to either "open" or "open as" or "import" this as a spreadsheet. Check the AppleWorks manual for importing standard formats if its not immediately obvious. A spreadsheet that doesn't open comma-separated or tab-separated text files is like a word processor that won't open a plaintext (simpletext) file--I certainly *hope* none exist!

That was a lot of detail and may sound complicated, but seriously, it should be like "click click click done." Once in the spreadsheet I always have to rearrange the columns to get them in the order I want for my invoices, but it works perfectly.