brgdotnet
asked on
how to copy excel spreadsheet data from an excel spreadsheet into a sql server database
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?
So how do I copy the data from the Excel Spreadsheet to a sql server database? I am using sql server 2008?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Excel is great in that users can do anything. Excel is terrible as a source of normalized data in that users can do anything to mess up the formatting so it can't be consumed, causing applications like SSIS and SSRS that require a 'contract' mapping of Source and Destination in order to pump data.
The above SSIS link looks pretty comprehensive. Would be worth spelling out some of that content in this question.