Button VBA to import a file

[Drew101]

Trying to figure out vba to put in a button that would import my file from the server into a table in access //HOMEONE\MFOLDER\UPLOAD.XLS


and then
A vba button that saves the query per the server address by the name completeupload.xls

//HOMEONE\MFOLDER\COMPLETEUPLOAD.XLS

[ranman256]

either:
attach the file as a linked table,
then you save each new excel file and overwrite the upload.xls
then run an append query to add the xl data to the internal table.

steps:
1, save upload.xls
2. run append query (in a macro)

OR

the button would run a macro,
the macro runs TRANSFERSPREADSHEET....
this command tells where to add the file into what table.