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?