Import xls data into table

  • Thread starter Thread starter Emily Edgington
  • Start date Start date
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
 
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.
 
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.
 
Back
Top