Exporting Data from QB

Posted by Yonder Dave PM | on Fri, 18/06/2010 - 10:45 556 2 comments | report

I have a client who is migrating from QB Pro (v6 on the opening screen) to Sage Instant (v16).

Sage has an Import function for Excel and CSV files, but when I went to QB all I could find is an Export function that produces IIF files.

I only need to do this for the customer and supplier records to save re-entering them in the new system. Csan this be done?

Yonder Dave

Comments

Export from QB

coolmanwithbeard | Fri, 18/06/2010 - 11:14 | Permalink

Hi Dave

This is not a problem - an iif file is merely a spreadsheet file laid out in a particular way

If you export (from the file menu) the lists you want (for simplicity I would do lots of individual exports rather than one mass export) you can open them in excel and reformat deleting the QB specific entries. Use save as to save them in a native csv or excel format as appropriate.

The only thing to note is that v6 is very old now - so don't attempt to run on vista or later!!

Mike

Export from QB

Yonder Dave | Fri, 18/06/2010 - 17:49 | Permalink

Thanks Mike

I will try that next time I visit.

Regards, Dave

Add comment

Exporting Data from QB

Export from QB

Export from QB

Pages