Member Avatar for davy_yg

Hello,

I am thinking about working with large picture galleries databases. Can you change excel sheet and make it importable into mysql tables?

I have to take 5000 photographies data and import them into the databases. I am thinking just to take the excel spreadsheet and convert it into mysql table.

How?

  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Can you change excel sheet and make it importable into mysql tables?

Yes, it can be done. You can convert it to CSV and the use fgetcsv() and prepared statements. Search for PHPExcel or similar. If you use MariaDB, a MySQL fork, then you can use the ODBC connect engine to attach the excel file to a table and run a query to insert the rows into the destination table, see:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.