Importing Excel Files to Access table

[jmh1]

Every morning I import an Excel file into the same Access database.

The excel file is a different file that is generated every morning.

The Access database is a MTD table that has all the daily files for the whole month saved.

Is there a Macro I can use to upload the excel file into access quickly?

 

[Smitty]

In Access, if you goto Macros-->New-->Action-->TransferSpreadsheet, you can set up a macro for that.

HTH,

Smitty

 

[jmh1]

Thanks very much for replying.

I wasnt able to find that menu section in Access...can you point me out to it please?

thanks!

 

[VicRauch]

When the database window is open in front of you (in Access), select the tab or button that is for Macros, then click the button New, go to the Action column, select TransferSpreadsheet and follow the directions there.