-2

I have an excel sheet which I have a column of 3 mixed data separated by a column.

I want to separate that data by comma and insert into three different Fields in Mysql.

enter image description here

Draken
  • 3,134
  • 13
  • 34
  • 54
Ajay Pal
  • 1
  • Look into https://github.com/PHPOffice/PHPExcel if it's truly an excel document and not a CSV file. Equally if it's one document, I'm sure you can do something manual. – jedifans Sep 14 '16 at 06:27
  • please understand the question... in first column information is seperated by comma . i want to insert the data in separate field – Ajay Pal Sep 14 '16 at 07:55
  • Perhaps give the schema and a bit of code that you've tried that doesn't work? – jedifans Sep 14 '16 at 08:05

1 Answers1

0

You have to create CSV file for this. So convert your XLS file in to CSV by Save AS & use below links will help

Community
  • 1
  • 1
Jackson
  • 1,426
  • 3
  • 27
  • 60