Import an excel document via a command button

[Access_Help]

Hi,

I have managed to export the data that I want into a spreadsheet using a command button.

Once my colleagues have completed the spreadsheet, I need a command button on a form with a file search dialogue box which will allow them to transfer the spreadsheet back into the database - updating the relevant records rather that over writing them.

Is there a VB code/Macro I can use which will allow me to do this?


Thanks in advance.

 

[bob fitz]

Why don’t you just create a form in the db for users to enter/edit the data that you are currently exporting to Excel. Controlling user actions can be handled very well from within an Access form.

 

[Access_Help]

Colleagues can update the spreadsheets at home and bring them back and update them into the database. I can't allow multiple copies of the database.