• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 593
  • Last Modified:

Using Excel, Access and Entity Framework together

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!
0
newbieweb
Asked:
newbieweb
2 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
Just to clarify the terminology here...
"Entity Framework" only really applies to ADO.net an the .net line of development languages.

When you are talking about MS Excel and MS Access, then common term is "Interoperability"

You can see here for a two techniques for transposing data:
http://support.microsoft.com/kb/202176

;-)

JeffCoachman
0
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now