I have an excel spreadsheet and I want to copy that data into a sql server table. Either a new table created upon import, or a table I create prior to the import. Whichever is the best technique.
So how do I copy the data from the Excel Spreadsheet to a sql server database? I am using sql server 2008?