Export DataGridView to Access with .net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ISATownsME
    New Member
    • Oct 2008
    • 3

    Export DataGridView to Access with .net

    Hello,
    I have a program that loads a datagridview from excel to visual studio. Can anyone tell me how to export the cell values of the datagridview to my access database?
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32633

    #2
    I suspect you will get more help from the .NET team on this one, although you should explain which flavour of .NET you are using. Please update with relevant details.

    I will move it across for you.

    Comment

    • Curtis Rutland
      Recognized Expert Specialist
      • Apr 2008
      • 3264

      #3
      If you have a datagridview, then you have the underlying DataTable available, right? The datagridview's DataSource property should point to it.

      You can set up an OleDb connection to access and loop through your DataTable, doing INSERTs.

      Comment

      Working...