Excel and Quickbooks

**sammisgram** · 11-20-2011, 02:46 PM

A friend saved an Excel spreadsheet and it somehow was saved as Quickbooks data. any ideas on how to open it...I've tried both Excel and QB and neither opens it. It's extension is .qbb.

Thanks,
Toni

**MarvinP** · 11-20-2011, 03:12 PM

Hi sammisgram and welcome to the forum,

Excel doesn't have a save-as to quickbooks. It looks like your friend did the following from quickbooks.
http://www.ehow.com/how_4449830_impo...uickbooks.html

**alansidman** · 11-20-2011, 03:15 PM

I don't have quickbooks file to test this, but you might try accessing the information using MS Query. Here is a link on how to use MS Query.

http://www.exceluser.com/explore/msquery1_1.htm

Alan

**arthurbr** · 11-20-2011, 04:04 PM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

**royUK** · 11-21-2011, 02:54 AM

Moved to Excel Miscellaneous

**royUK** · 11-21-2011, 02:58 AM

I can't find an option to save as .qbb from Excel. I suspect ir was exported from QuickBooks but not to Excel format. Recreate the file from QuickBooks