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?
L3ZL1E posted this at 16:31 — 18th September 2007.
They have: 32 posts
Joined: Feb 2007
I found Navicat software...but the special characters still are not rendering correctly.
Any suggestions?
pr0gr4mm3r posted this at 18:49 — 18th September 2007.
He has: 862 posts
Joined: Sep 2006
You shouldn't need the htmlentities function, just send this header before any output:
<?phpheader('Content-type: text/html; Charset=UTF-8');
?>
PHP Starter - PHP Tips & Tools From Starters to Experts