J John liem Registered User. Local time Today, 15:36 Joined Jul 15, 2002 Messages 112 Feb 3, 2003 #1 How can I upload a list of material in an Excel format into an Access table by using a button (VBA).
FoFa Registered User. Local time Today, 08:36 Joined Jan 29, 2003 Messages 3,672 Feb 3, 2003 #2 One time, manually, use get external data and import it. User when ever they want, transfer spreadsheet from either a macro or VBA.
One time, manually, use get external data and import it. User when ever they want, transfer spreadsheet from either a macro or VBA.
J John liem Registered User. Local time Today, 15:36 Joined Jul 15, 2002 Messages 112 Feb 4, 2003 #3 Hi FoFa, I've managed to write a short routine to empty the table and upload the new Excel data onto this table using a button. Thanks FoFa for your reply!.
Hi FoFa, I've managed to write a short routine to empty the table and upload the new Excel data onto this table using a button. Thanks FoFa for your reply!.
