BCP utility to create a format file, to import Excel data to SQL Server 2008 for BULK insertion

Question

Am trying to import Excel 2003 data into SQL table for SQL Server 2008.

Tried to add a linked server but have met with little success.

Now am trying to check if there's a way to use the BCP utility to do a BULK insert or BULK operation with OPENROWSET, using a format file to get the Excel mapping.

First of all, how can I create a format file for a table, that has differently named columns than the Excel spreadsheet colums? Next, how to use this format file to import data from say a file at: C:\Folder1\Excel1.xsl into table Table1 ?

Thank you.