Store Temp Information

[Herdrich]

Hello,

I currently have an access database that compares information in a table to data that is stored in an Excel document and displays the information that is the same. The two things that it compares is first and last name. When using the program i currently have an Excel document located on a shared drive that users open by hitting a button in Access then the user copys the names from an Excel document to the one located on the shard drive. The information is uploaded and compared displaying the results. The downfall of this is that only one person can be using the program at a time.

Now my question is there a way to store the information the user is copying in to a temporary location instead of using the file on the shared drive. I tried using another table to input the data but was unable to paste the data in.

Thank you for your help.
~Glenn

 

[PHV]

Have you tried the DoCmd.TransferSpreadsheet method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Herdrich]

I am partly already using the DoCmd.TransferSpreadsheet command. When a I compare a lists it transfers the static database in case there is any changes then transfers the variable database then compares them both and provides the results.

I am looking for a way to not have to open an outside excel document paste the information save it then import it.

Is there a way for me to paste information into a table or something similar?