I have multiple excel file that I need to get into sql. I need the file name to be a variable passed by a stored procedure. I part I am having a problem with is how to I get it into a sql table. I know I need to create the temp table, but when I try a bulk insert the line all runs together into one column. I also need to parse out the lastname and first name when uploading. I'm really desperate to get this working today. Any help would be greatly appreicated.
The rows in my file are set up as
Name DOB Age Chart# VisitDt Provider Office Diag1 CPT SSAN Sex Address City State Zip Rating
Test,Justine 13-May-61 44 s1234 10-Jan-06 d59 mfc 296.7 99211 512-41-4444 m 123 Test Street Test City CO 12457 z