Solved

Link Excel file to an ADP project

Posted on 2009-04-14
4
300 Views
Last Modified: 2012-05-06
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
Comment
Question by:meredithf
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:SimonThompson
ID: 24140616
I dont think you can as the data comes directly from SQL... can you get the user to update the data in access?
0
 

Author Comment

by:meredithf
ID: 24140758
They're not really into access.  They want to do everything in excel.
0
 
LVL 3

Expert Comment

by:SimonThompson
ID: 24140767
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
 

Accepted Solution

by:
meredithf earned 0 total points
ID: 24140873
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DBF to ... Converter 5 40
Excel Automation VBA 19 33
Excel macro runs twice 13 50
How autonumber field on a form 16 14
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now