Import Excel into Access with Multi User environment

[jlgray0127]

Hi.
Hopefully an easy one.
I'm using Access 2010 and this is a multi-user environment.
I am creating a mini MRP system, basically. My end users, have multiple projects they run, and track through Excel. When they are making requests for material, they can request one item, or over 200 items at one time.
What I have done, is created a table, which contains the basic information I need from them. I created an export to excel for them, so they simply have an excel version of the table I need to upload into my database for their requests.
Since our PC's are user specific, C:\Users\johnSmith\Desktop, for example, I can not seem to figure out how to the let the end user import the file by just clicking a button on the form, after they paste their information into the spreadsheet template.
I would like someone to help me import the template file, allowing the end user to click the button to import, select the file location, and then for it to just paste the information into a temp table for me to scrub the data.

Simple, right?

Click Import
User selects file name (Copy of Template in Excel)


Access appends the data to Temp Table, or creates a Temp Table

I can do the rest...

Any help is greatly appreciated. Truly sorry if that sounds really confusing to get to the simple summary. Thank you in advance!!!!

[June7]

Will every user have the file on their desktop? Is the "johnsmith" folder name the same as the user network login? Retrieve the username with:

Environ("USERNAME") - yes, type it exactly as shown.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tablename", "C:\Users\" & Environ("USERNAME") & "\Desktop\spreadsheetname.xlsx", True

If you want to allow users to navigate to and select file, use FileDialog to capture the filename - common topic in forum. https://www.accessforums.net/program...ice-48264.html