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.
Any help will be greatly appreciated.
I dont think you can as the data comes directly from SQL... can you get the user to update the data in access?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.