Excel import

[onkey]

Hi...
i new in MS Access 2007.

i hv one project using this application(access)




how to upload data from excel workbook into access?
i have a few workbook to upload into access..
my boss want me create button for upload,so went i click that button i can choose which workbook i want to upload..
all the excel i put in sharefolder(company).

[June7]

A number of ways to accomplish. The simplest is for the button to open the import wizard.

DoCmd.RunCommand acCmdImportAttachExcel

Beyond that, starts getting complicated.

Can open Windows file manager dialog to navigate to file and grab file name then use it with TransferSpreadsheet method to execute import.
http://support.microsoft.com/kb/824272
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx