A little help with MS Access

[Team Slayer]

I want to import an .xls (Excel) file into an Access Table. The first row of the .xls file contains the column names. I know this can be done manually by clicking on File -> Get External Data -> Import. But, I have to automatize this...I'm thinking of using a Macro, but I don't know which Action to associate with the Macro.

Any help would be GREATLY appreciated.

[Schiller]

Transfer spreadsheet I believe should do it

[Team Slayer]

(edit)

thanks!

[Team Slayer]

commay, you tha MAN!!!!!!! thank you :1:

[Schiller]

no problemo boysie