Use those modifiers with any MySQL query to create tab-delimited files that Excel can open. After loading the data into Excel, you are free to save your new spreadsheet as an XLS or XLSX file as ...

Use the Excel file as an ODBC data source (connection string info here), and your MySQL database as the destination (using their ODBC connector). What OS is your process running on?

How can I get this nominally UTF-8 file into MySQL successfully? For what it's worth, if I open the UTF-8 file in Notepad or re-open it in Excel, it looks fine.<BR><BR>Thanks for any help!

Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime. As much as it can be a pain, a lot of projects still require that you import data ...