What is the correct way to import and export out of Excel to SQL Server and back?
- by Vecdid
Looking for the correct way and control to import and export of out of Microsoft Excel programmatically.
I am willing to get a 3rd party control that supports this functionality, or I can create it myself, but looking to get this prioject done fast.
The Datasource will be offline. Although when it is online for the upload/download if there is a control that would merge them, that would work also. But best is to remain offline, don't need the support headache. Security is also an issue.
SSIS is not available on the shared database server.
The website that hosts the asp.net application is not on the same machine as the sql server.
Thank you.