I want to import an excel sheet to a new table and capture the first row from the excel sheet as the table field names without using the import wizard. Any help would be greatly appreciated. In the example below I want to import this into a new table and make NAME ID CODE PHONE the field names.
.....A......B.........C........D
1..NAME....ID...CODE.....PHONE
2..JOE B...1234..R.......555-1234
3..BOB H...2345..P.......555-2345
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson