I have a MS Access 2003 Database with about 5mb of information that i'd love to have a copy of and ability to update on Web Excel...since Access is not available. I'd like to think this would be an easy copy and paste situation, but I doubt it's that easy. The machine is using Windows Vista and Microsoft Office 2003 as I said. Please advise the easiest method or if it's even possible at all. If I can even simply use Web Excel as a place to have a back up copy without having the ability to update that would be ok as well, as long as I can do this often and easily. Thanks
Hi there, and welcome to the forum!
One thing I'm curious about... is all of your data stored in a single Access table? If so, then you could try:
From there, you should be able to pull your data in. Then save the file up to your skydrive and it should convert to an xlsx file for you automatically.
- Go to Data --> Import External Data --> Import
- Browse for your database
- Follow the prompts
I'd have to ask if you really want to go there though... if it's in Access now, I'd assume that the data is a bit more structured/complicated than Excel is designed for?
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.