We have a 2 company license on our Sage, and are in the process of transferring all business from one company to the other - including all the customer and suppliers of which there are over a thousand.
I can see how to import the data into the other company via the CSV file - and the format that it needs to be in, however I can find no help whatsoever about how to export the data into a CSV file.
If I've understood the question correctly you're effectively merging the 2 companies and they have different customers and suppliers. ? In which case you can't do as Jeremy suggests.
To export to csv: pick the report data you want to export, click on print preview and at the top there's an export icon. Save your data using .csv option
Thankyou for your replies - however the 2 companies are not merging, we are just transferring the main trading from one to the other - they are both still going to keep trading side by side for a while. I had considered the data rebuild option but there are many different nominal codes between the 2 companies and some of the customers and suppliers are already on the new one and were done manually and thought it might corrupt the data already on there that I needed to keep and there are still many hundreds left. I tried to export by getting the supplier/customer address list which has all the info on, however when you import to CSV it just brings it up on the spreadsheet in the same format, ie with the address lines going down the page instead of across - am I missing something glaringly obvious? Quite probably I think!...
