create a button for import excel file

[tggsun]

Hello all,
I'm a new one to use Access.


I have a lot of data files whidch need to be imported into access database. the fields' are identical for excel and access database.
I need to create a import button to import those excel files.
I searched on internet and could not find out a course to teach me how to do that. Is there anyone knows that (anything would be fine, such as course, video, book or link ... or your tip)?
Thank you very much!
dd sf

[Robeen]

Will you be importing the data from these Excel files on a regular basis?
Or will it just be a one-time thing?

[tggsun]

I'll do that on a regular basis. That's why I would like to create a button to do that.
Thanks,
dd sf

[Robeen]

I use Macros to do this on a regular basis.
What I do is:
Create a new Macro in design View.
Make the first Action in the Macro - SetWarnings = No.
Next Action OpenQuery - to run a Delete query that deletes the previous day's data from the Access table that will be receiving today's data from the spreadsheet.
Next Action - ImportExportSpreadsheet - to import data from the spreadsheet to the table from which you just deleted the previous day's data.
Final Action - QuitAccess.

I have all these actions in a Macro named AutoExec.
I have a Windows Scheduler Scheduled Task that opens this database early in the morning before I get in to work.

It has worked really well for me.

Let me know if you have questions.