Import xls data into table

E

Emily Edgington

I am using Access & Excel 2000, and cannot get this command to create and
load CheckLoadTemp table. I created a form with a button that points to this
code, but when I click the button, nothing happens. Please help.

Private Sub cmdImport_Click()

DoCmd.TransferSpreadsheet acImport, 8, "CheckLoadTemp",
"c:\temp\UnclaimedChecks-test.xls", True
Me.Visible = False
End Sub
 
S

Stockwell43

Hi Emily,

Try to create a macro and use the "TransferSheet" in the action drop down.
Below that, fill in the information and then go to your button and in the
onclick event, select the macro. Not sure if it's what your looking for but
will only take a few minutes to do and may be helpful.
 
E

Emily Edgington

Disregard. The OnClick property of the button was not set, so the button
wouldn't kick off the procedure.

Yes, I'm new to this.
 
Top