Export/Import Excel/MySQL
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: 1,502 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');
?>
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.