<div>
<div class="content wysiwyg-content">
I need to write a Windows program for transposing certain columns of data from specific rows (in an Excel spreadsheet) into database updates. Although the requirements are not yet very clear, I am trying to see how Entity Framework can help me.<br />
<br />
How do EF and Access work together? Would I create an EDMX file the way I have done with a SQL Server database? &nbsp;Then would I use Linq queries to access the data?<br />
<br />
Thanks!
</div>
</div>


I need to write a Windows program for transposing certain columns of data from specific rows (in an Excel spreadsheet) into database updates. Although the requirements are not yet very clear, I am trying to see how Entity Framework can help me.

How do EF and Access work together? Would I create an EDMX file the way I have done with a SQL Server database?  Then would I use Linq queries to access the data?

Thanks!

Using Excel, Access and Entity Framework together

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.