Moving data from Excel to Access

ChrisWalsh · April 14th, 2005, 07:43 AM

Hi all
I would like to add a button to an Excel spreadsheet that will read data from several (non-contiguous) cells and copy that data into the next available row in a pre-defined and constructed Access database.
Any help with this would be appreciated
Cheers
Chris

BrianWren · April 14th, 2005, 12:13 PM

Once you have your data, you can build it into an SQL string, and append it to the table with the something like the following:

Code:

Sub Whatever()

    Dim db     As Database
    Dim strSQL As String

    ' Define SQL statement for action query.
    strSQL = "INSERT INTO tblMAIN (   Fld1, Fname) " & _
             "VALUES              ('Stuff', 'Bob')"

    Set db = OpenDatabase("MyDB.mdb")
    db.Execute strSQL

End Sub