MrExcel Publishing
Your One Stop for Excel Tips & Solutions

import


Posted by Bill L. on March 18, 2000 12:24 PM

I have a friend that uses "QuickBooks." Doesn't want to learn the ins and outs of the program. Told him I thought I could do a simple presentation of his data...client lists, purchases, dates etc. I haven't received the data yet, just wondering if it was easy or not, and whatever prep I should do...what I can expect. I don't have the program myself. Can Excel 97 import it directly, or should I have him export his file other than straight QuickBooks format. Whatever that is?


Posted by bill.roberts on March 21, 2000 6:44 AM

Bill,

Not too sure about QUICKBOOKS but it might just be able to save data in an EXCEL format.

Or, it might be able to save the data in an intermediate format which could then be saved in an EXCEL format.

By intermediate, I mean perhaps MS MONEY. Being a MS product, MONEY may allow a straight migration to EXCEL.

I run into incompatibale downloads quite frequently.

Many of the proprietary packages I use will produce an ASCII report which I import into EXCEL via a macro.

Macro's (pardon the instruction) are great when used to "normilize" data.

Some of my raw data can consume 3 or more rows with some cell values split between 2 or more cells. Heck, they can also occupy more than one row.

Bill

Posted by Bill Lean on March 23, 2000 1:48 AM

Bill,
Thanks a ton for responding.
I've learned in the interim that Excel can import this format. I was worried about headers, etc. Easy enough to get rid of, just was wondering if it had a quirks I should know of. Also found a program called "byte boy"...haven't tried it, but can supposedly convert any data file to Excel. Probably just better to hack it out on your own though. Thanks again.
Bill

Posted by bill.roberts on March 24, 2000 7:48 AM


Bill,

Thank you for your kind words!

-----------------------------------

I did a search for BYTE BOY and found nothing.

I'd like to check it out.

Where is it?

Bill