Using SQL Server 2008 Table-Valued Parameters (TVPs) from Access

“Table-valued parameters (TVPs) in SQL Server 2008 provide an easy way to marshal multiple rows of data from a client application to SQL Server without requiring multiple round trips or special server-side logic for processing the data. TVPs come in handy when you want to code explicit transactions inside of stored procedures, performing multiple data operations as a single unit of work. You can encapsulate multiple rows of data in a single parameterized command. The incoming data rows are stored in a table variable that can then be operated on by using Transact-SQL.”

To learn more, see the blog posting that one of our documentation Writers, Mary Chipman, has written.

About the Author
Mary Chipman is a programmer-writer for the Data Programmability team at Microsoft. She was recently profiled in Women in Technology for TechEd Online at You can find the online panel she hosted at TechEd 2008 by going to and searching for: “Are we there yet? Successfully navigating the bumpy road from Access to SQL Server”. Mary will also be presenting at TechEd 2009 ( on the topic of working with SQL Server from Access.