Importing Excel file without server access

[Alex]

I'm automating the process of emailing query results as an Excel file
attachment to one recipeint. The recipient will complete data in the Excel
file. My problem is that our company will not give this person access to our
server, therefore he cannot upload his updated Excel file to one of our
drives where I can then access it, import and update my table. There is
nobody that he can email the file to either. I believe, however, that he'll
have access to unpload a file to our company's SIFT site. Is there a way,
through automation, that I can then import the file from the SIFT site and
update my Access table?

Thanks so much

 

[golfinray]

Normally, I use the transferspreadsheet method. Like this:
DoCmd.TransferSpreadsheet acImport, , "0911 disbursement",
"P:\fileshare\milton copy 0911 disbursement", True
Give it the name of the spreadsheet, the location, and the true tells it the
first row is the headers. You could use a command button and put this in the
onclick event. Get that imported and then use an update query or append query
to update you table.

 

[De Jager]

I'm automating the process of emailing query results as an Excel file
attachment to one recipeint. The recipient will complete data in the Excel
file. My problem is that our company will not give this person access to
our
server, therefore he cannot upload his updated Excel file to one of our
drives where I can then access it, import and update my table. There is
nobody that he can email the file to either. I believe, however, that
he'll
have access to unpload a file to our company's SIFT site. Is there a way,
through automation, that I can then import the file from the SIFT site and
update my Access table?

Thanks so much

 

[joelgeraldine]

tthhhhhhh