TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dave dieckmeyer
NA
2
0
Excel and Access project
Aug 28 2007 4:48 PM
I am working on a project that uses both Access and Excel. The Access db I built contains relatively stable data (does not change much) but the Excel data will be replaced every month - its a monthly budget report (downloaded from a legacy app). The unmodified, downloaded spreadsheet is incomplete.
I want to build an application that will modify the Excel sheet by adding a column of descriptions based on the content of an adjacent cell within that same sheet. I will then need to add several rows to the top of the spreadsheet (6 rows) for the header information, which will be unique and also based on the content of a cell. the data for these two tasks will come from the Access database.
I have connected to the db and the spreadsheet and have been successful at creating a dataset. but now I'm not certain of what my next step should be. Any suggestions/help?
thanks,
Dave
Reply
Answers (
0
)
Excel sheet modification