Export/Import Excel/MySQL

They have: 32 posts

Joined: Feb 2007

Does anyone have any recommendations for software to import/export to/from Excel to MySQL as well as the ability to update records manually. I am currently using EMS SQL Manager for SQL 2007.

I was also told about possible using FileMaker to perform the same actions, but couldn't see where I could update records manually.

One last thing, my apostrophes are not completely converting and are showing up as special characters. I have the table set to UTF-8 as well as am using the php code $var=htmlentities($row['VAR], ENT_COMPAT, 'utf-8'); Could it be that the first conversion, from InDesign to Excel, be creating this problem?

They have: 32 posts

Joined: Feb 2007

I found Navicat software...but the special characters still are not rendering correctly.

Any suggestions?

pr0gr4mm3r's picture

He has: 1,502 posts

Joined: Sep 2006

You shouldn't need the htmlentities function, just send this header before any output:

<?php
header
('Content-type: text/html; Charset=UTF-8');
?>

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.