I have an ms excel spreadsheet with two columns
Col1 Col 2
House Title Grove street, 10478
I want to import the data from excel into a table in Microsoft Sql Express.
My table has four columns
ID int (auto increment)
I want to import from the excel spreadsheet into the table so the above excel line would be imported as
Title "House Title"
Street "Grove Sreet"