Import button

TheSafetyGuy86

Registered User.
Local time
Today, 02:39
Joined
Jun 18, 2013
Messages
31
All,

Good day! i am trying to add an import command button to a form so that personnel not familiar with Access can simply push the button and then select the file to import. I want it to import information to a specific table by replacing all records in the current table with the import. I am not the best at coding, but I can understand enough to figure out what I may need to do. Please let me know what I need to do.

To make this simple, I will be exporting a table to excel from the database. Multiple people will have this database and often times will not be able to access a shared database, so I need to export the table and then set up a way for them to import the excel document into their database by deleting the information in the old one and then updating to the new one. Please help!

Lee
 
Take a look at the TransferSpreadsheet function and search this site for the CommonDialog.

As a neophyte, you have a hard row to hoe ton accomplish what you want.
 

Users who are viewing this thread

Back
Top Bottom