Table and Query updates

[alagowski]

I have a file in excel that is updated monthly. Updates include new records being added and the old records being updated.

My goal is to have this excel file imported into access 2007 and to write several queries that are run every time the new file is imported from excel.

Is there a way to have queries run automatically when a new table is imported? Any insight would be greatly appreciated as I am a fairly new access user.

Thank You.

 

[spikepl]

Lookup TransferSpreadsheet method in Help.
Write code to run it. Add your queries to that code. Run the lot from a button.

Actually, you probably can get away with making a macro for all this (I'm no good at macros).

 

[newbee1]

Hey,im sorry to turn this around but i have a simple question.Im currently working on a login form.ive got the code i want to validate the id,email adress and password of a user using DLookup.but the trouble is ,after it validates it adds the entered data into the table! so in the end I have 2 of the same records in the database.Is this a common problem?here is my code.Its pretty simple.
Private Sub cmd1_Click()

If (DLookup("Password", "table1", _
"[ID]=" & Me.txtid.Value)) > 0 Then

'Close logon form and open splash screen

DoCmd.Close acForm, "f1"
DoCmd.OpenForm "f2"

Else
MsgBox "Password Invalid. Please Try Again", vbOKOnly, _
"Invalid Entry!"
Me.Password.SetFocus
End If


End Sub

 

[spikepl]

@newbee1

Thread hijacking is frowned upon because it confuses the issues. Please start you own thread. You have just been issued with the same request in another thread, so do show care.