Go Premium for a chance to win a PS4. Enter to Win

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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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