Macro in MS Access to import excel file

[spatel]

Hello,

I am trying to create a macro in Access that'll import an excel file and append it into a access table. Currently, the macro is appending the records in the specified table howerver, I want the user to have the ability to select the file for import.

My macro is invoked by a button on my form but it'll only import the file that is specified in the path another words its static.

On the form, I want the user to select the .xls file from whatever location and then hit the button to import that file into the access talbe. How do yo do that?

 

[spatel]

Thanks. I just changed the .mdb to .xls to view the .xls fie. Its show up now. Thanks

For the append.

I am using a macro. Where the action is "TransferSpreadsheet" The problem is its selecting the file thorugh the FileOpen Function but then how can I save the filepath and in that macro which has the table I want to append into.

Another words, the filepath is save in a variable in the code. Do you think I can use that same variable in the macro or can I just call the function from the macro.

Basically, I just want the user to select the file via a button and then import that same file via a button. Thats it. The first half is done. How can I save the filepath from the function and then use the macro to append the records in the table.