• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Link Excel file to an ADP project

I have an Excel file which the user will update from time to time.  How do I link that Excel file to my ADP project?

Any help will be greatly appreciated.
0
meredithf
Asked:
meredithf
  • 2
  • 2
1 Solution
 
SimonThompsonCommented:
I dont think you can as the data comes directly from SQL... can you get the user to update the data in access?
0
 
meredithfAuthor Commented:
They're not really into access.  They want to do everything in excel.
0
 
SimonThompsonCommented:
Not sure how it can be done, sorry. I suppose an option is to use DTS in SQL to update a table from and excel sheet on a shedule?
0
 
meredithfAuthor Commented:
I guess I'll just create a function that will upload the data from the Excel file to a table in the ADP.

Thanks Simon!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now