Hello all,
I've never used MS Access before but I know it handles database stuff. (I think) Well if it does, I was wondering is it possible to do some work in Excel and then import it to the MS Access DB which will update the actual SQL database? Essentially right now, I do some work in Excel then I import it manually via a web interface. Can I further automate this using a combination of Excel and Access or should I just learn how to connect to my SQL database with VB in Excel itself?
I've never used MS Access before but I know it handles database stuff. (I think) Well if it does, I was wondering is it possible to do some work in Excel and then import it to the MS Access DB which will update the actual SQL database? Essentially right now, I do some work in Excel then I import it manually via a web interface. Can I further automate this using a combination of Excel and Access or should I just learn how to connect to my SQL database with VB in Excel itself?