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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Data from Ranges on a Worksheet 3
Module Import error: Compile err 1
how to import multiple Excel files into multiple Access tables? 9
Importing From Speadsheet 2
Excel file won't import unless open 1
Problem Importing Specific Worksheet From Workbook 6
Excel File won't Import into Access 1
check before import Excel file 4

Top