PDA

View Full Version : getting data from Excel into SQL



newbie83
01-30-2015, 09:27 AM
Hi all,

Not sure im in the correct place for this question but here goes.

Is there a way of getting data from excel into SQL Server express, i have already tried building a package in Visual Studios and attaching that to a button in excel, this approach would work great if i had a licensed version of SQL Server.

the package works but needs executing manually everytime i need to send data to SQL.

so my question again is, is there another way around this issue?

Thank you for your time