Import button (1 Viewer)

TheSafetyGuy86

Registered User.
Local time
Today, 03:54
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
 

llkhoutx

Registered User.
Local time
Today, 02:54
Joined
Feb 26, 2001
Messages
4,018
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

Top Bottom