Macro to automate the process of importing a excel sheet into access (1 Viewer)

[acesQuer]

Hi,

I am trying to replicate the process of importing excel file into ms access as a table. Is there any way of doing it??

Currently, I am manually getting it done via External Data--> Import Excel Spreadsheet.

What I would like to achieve is to have a macro whereby a click of a button will get the spreadsheet into access as a table.

Thanks

 

[boblarson]

Look at the macro Action of TransferSpreadsheet (or the VBA of DoCmd.TransferSpreadsheet).

 

[MI man]

As BobLarson said, use docmd.Transferspreadsheet

Write it as code or as a macro and assign it to a click button, if you have a Form in Access...