June 2, 2011 at 4:04 am
How to update records in a table from Excel sheet?
I have a table called 'Transaction_Matrix'. I will connect this table with excel sheet. Then I will share this excel sheet to my team members and update the relevant information from the excel. If the team members updated anything in excel, it will be reflected in the DB.
How to acheive this from excel macro? could you please give me a step by step process from excel?
June 2, 2011 at 7:21 am
I have to say that sounds like a really bad idea. You are in effect using Excel as a UI for a data application. How do anticipate validating input? There are so many problems with this in general. It would be a lot less work to just use a databound and editable datagrid. If you are determined to use Excel you will have to make a connection and run some sql via vba code. Google is your friend for this one.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply