Results 1 to 2 of 2
  1. #1
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    144

    Import Excel into Access with Multi User environment

    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!!!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,658
    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
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Split DB Question - Multi User Environment Launch
    By aussie92 in forum Database Design
    Replies: 6
    Last Post: 01-22-2014, 03:19 PM
  2. Replies: 3
    Last Post: 06-14-2012, 08:10 AM
  3. Record Locking Multi User Environment
    By praetorianprefect in forum Database Design
    Replies: 5
    Last Post: 04-16-2012, 02:31 PM
  4. Replies: 0
    Last Post: 03-14-2012, 07:23 AM
  5. Replies: 13
    Last Post: 05-18-2010, 01:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums