KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have imported data from some Excel file and I have saved it into a datatable . Now I'd like to save this information in my SQL Server database. I saw a lot of information on the web but I cannot understand it: Someone said insert line by line another suggested bulk update... etc: what it better? Should I use OLE or SQL Server objects (like dataAdapter or connection )? My need is to read the employee weekly hours report, from his Excel file and save it to a database table where all the reports are saved (updating the db with new records every week). The Excel file contains reports only for the current week.
Tags (comma-separated)
Save Edits
Cancel