troubleshooting Question

vba code to import data from a shared drive to an access

Avatar of Fordraiders
FordraidersFlag for United States of America asked on
Microsoft AccessVBA
8 Comments2 Solutions28 ViewsLast Modified:
vba code to import data from a shared drive to an access table

No Linked worksheets.

I need to import excel worksheet from a network drive
and then append to a access table.

cant use saved import or a Linked table.

  Set appExcel = CreateObject("Excel.Application")
  Set myWorkbook = appExcel.Workbooks.Open("\\\files\Office\NB\MK\sales support\Rebates_Import\Qualifier_Entity_LOV.xlsx")

Sheet  Name  =  "Sales_Adj_Terms_LOV"

Access table to append to = "tbl_Import_Qualifier"

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros