Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RajivRK
Starting Member
1 Post |
 Posted - 2014-03-10 : 05:33:10
|
| how can Live Excel data(data here changes every second)be imported into SQL Server? |
|
|
Mar
Starting Member
47 Posts |
Posted - 2014-03-11 : 08:02:05
|
| Are you saying you want to do an update every second? I don't think that is a good plan. Where does Excel get the data from?If you really want to go that route then you could use VBA. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-03-12 : 02:47:58
|
| Do you mean , using the Excel as a front end - which soon as is entered into Excel is streamed into SQL Server? or do you mean a scheduled batch job?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Live Excel Data into SQL Server.