• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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