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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Live Excel Data into SQL Server.

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.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -