export from excel to ms sql

[jackvull]

Is there an equivalent to LOAD DATA INFILE to export from Excel to MS SQL server?
I need to upload a file through PHP to do this.

ALso, might it be better to upload the file to the server and then run a command locally?

[phparion]

you can use the word LOCAL with load data infile if the file is on your system. You don't need to upload it.

have you checked mysqlimport command and phpmyadmin? there are many other softwares which allow you to upload different format files to SQL database through GUI.