• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Export specific page col and Rows data of Excel to MY SQL Database

T

Techtrend

Member
Hello

Want to Export my Dashboard Excel Sheet Data To My Sql Database in a real time basis or in Different time intervals

For Ex every 2 MINS

Please let me know the Steps if its doable,

Regards
Satish
 
I don't recommend this. It's far safer to read/import Excel data from SQL side.

Set up job and stored proc in the database to handle it. Though without any detail on how Excel is being updated and from where. Hard to give you pointers.
 
Hi

The sheet Data Is RT DATA,
Gets updated from Trading terminal in real time and data keeps changing

And we have used logics and strategies based on which filtered calls are generated,The final filtered data comes in a sheet which is called dashboard,
Only the dash board sheet has to be Synced to the database.

Hope its cleared
Thanks for helping me
Kumar
 
Then why not connect directly to Trading Terminal from SQL? Or push data from Trading Terminal to SQL?

Still not enough detail to really help you. Check some of sample ADO codes you can find on this site or via Google search.
 
You must log in or register to reply here.
Back
Top