Hello Mark,
In Excel, export ( File->Save As) the worksheet as Comma Separated Values (CSV) File (OR TEXT file as per your query). Then in phpmyadmin, use the import feature and select appropriate CSV option.
Note that some installations don't show all options, just SQL Server in import options. In that case, you'll first have to export the data from Excel to an SQL Server file using some other tool such as SQLYog
That should ease this cumbersome process for you.
Regds
IJ
|