Link to home
Start Free TrialLog in
Avatar of meredithf
meredithf

asked on

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.
Avatar of SimonThompson
SimonThompson

I dont think you can as the data comes directly from SQL... can you get the user to update the data in access?
Avatar of meredithf

ASKER

They're not really into access.  They want to do everything in excel.
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?
ASKER CERTIFIED SOLUTION
Avatar of meredithf
meredithf

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial