How to import excel file into Access table?

[polina]

Hello,

I need to code the process of importing the excel file into the Access. The excel file name and location is known and therefore I should open a window so the user would choose the file to be improted himself.

Please help.
Thaks.

 

[ListO]

Look up "TransferSpreadsheet" in Access Helpfiles.

 

[ghudson]

Check these API's out...

API: Call the standard Windows File Open/Save dialog box

API: BrowseFolder Dialog

HTH