We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Upload and Append an Excel Spread sheet (.xls) to an Access Database using ASP

fgict
fgict asked
on
Medium Priority
615 Views
Last Modified: 2008-02-01
Hi

I would be grateful for your expert help on the following issue.
Many clients continue to have their customer mailing list in excel format and do their (add / edit / delete) updating of this list offline. We have a simple mailing list application on each of their websites containing just 3 fields Name, Email & Date Joined in an access table.
When they wish to send out their mailing list through the website administration screen, they basically need to have their most up to date version uploaded.
My question is what is the best method to achieve this?
Is their some .asp code out there that can take their .xls spreadsheet, upload to the server and append or overwrite the fields to the access table or does this work need to be done offline and then uploaded?
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.