Convert this XLS file to CSV to enable import into a SQL database.
We are migrating from MYOB “Just Invoices” accounting system to a new SQL database software package and wish to export the customer database information.
MYOB “Just Invoices” has very limited ways to export data. Limited to PDF, RTF, XLS or HTML file formats. The method that seems the most appropriate is to first export the Customer details to a *.XLS file for conversion to CSV. Unfortunately as you can see the attached XLS file layout is separated into many pages and cannot be converted to CSV effectively.
We require the data sorted in a uniform way then converted to a CSV file for the import.
E.g.
Code,Campany,Number,Street Name,Suburb,Town,State,Post Code,Contact,Phone,Phone,Fax,Web Site,Email,Sales Rep
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.
Hi, I'm experienced PHP&MySQL developer with strong knowledge of data processing. I'll kindly filter, process, and export any data from excel to csv, without any data loss or corrupted. Please feel free to ask me any question via PMB. Thank you for your time.
Hi,
I have more 10 years experience in MS Office automation (Excel, Word, Access) so I'm realy GURU it this.
I can help you with this project.
Best Regards,
Alex
Hello,
This is wasy for me, I already developed a VBA that brought the info in a second sheet, all I need to do is arrange the addresses. Please see PM for intermediate file (work in progress) that will be ready tomorrow if you choose me. Thank you, Emmett.