Import excel sheet button

[Trilback]

I have an access database that I am working on. What I want to be able to do it import an excel sheet into the database using some vba to make it easier for someone else to update a table of mine. Right now I have updated this table using the Import & Link under the External Data. Every so often we get a new excel list of agents that needs to be imported into the database. I have coded the database to use the default field names as everytime we import it will never change. I have found online that I can use "TransferSpreadsheet" when I tried but I don't see what am I doing wrong and part of me thinks I need to load a references under VBA. Please advise.

 

[sneuberg]

You do not need a reference for the DoCmd.TransferSpreadsheet Method. I suggest you post what you tried and tell us what it is and isn't doing.

 

[Trilback]

Well it's been a week or two since I am worked on that part of my database. I think what I was trying to do is either have it so someone would click a button and then have then choose the file to import (The name would be different each time but the cell headers and field name for the db would stay the same) or just make the person rename the file and to the name I give it in code then have them push the button to import. If I can do a bit of both who having the choose box pop up but still have it import that would be great but I am ok with my TransferSpreadsheet code that I already have (I should be able to get that part to work).