9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
I'd like my macro (in an Excel 2010 workbook) to copy values from three worksheet cells and append them to an existing Access or SQL database file -- without having to leave my Excel spreadsheet or open any other programs. The database file simply needs to be appended. Keeping a running list. That file isn't being used for anything else, we can set it up however is necessary to do this.
For example, Excel cells A1, A2, and A3. Representing Job Name, Job Number and Job Total.
Can anyone tell me how make VBA do this(in SIMPLE terms)? Or give me a link of where to look or what to search for? I understand VBA but not Access or SQL.
THANK YOU!
P.S. If this gets posted multiple times I sincerely apologize. The last two times I tried to submit this post I got an error saying I needed to log in/become a member, even though I was logged in already. I checked before reposting to make sure it hadn't posted, but with my luck there was simply a delay.
For example, Excel cells A1, A2, and A3. Representing Job Name, Job Number and Job Total.
Can anyone tell me how make VBA do this(in SIMPLE terms)? Or give me a link of where to look or what to search for? I understand VBA but not Access or SQL.
THANK YOU!
P.S. If this gets posted multiple times I sincerely apologize. The last two times I tried to submit this post I got an error saying I needed to log in/become a member, even though I was logged in already. I checked before reposting to make sure it hadn't posted, but with my luck there was simply a delay.