Importing Excel Files to Access table

jmh1

New Member
Joined
Aug 4, 2005
Messages
43
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?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
In Access, if you goto Macros-->New-->Action-->TransferSpreadsheet, you can set up a macro for that.

HTH,

Smitty
 

jmh1

New Member
Joined
Aug 4, 2005
Messages
43
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

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,708
Members
410,630
Latest member
Maggie28
Top