convert access databases to excel

[Guest]

I have lots of databases on Access, I need to change them as our new system
will not support access, someone said its easy to convert them yo excel and
excel can do everything access can...personally I'm not convinced, can anyone
help?

 

[Douglas J. Steele]

It all depends what your current databases are doing.

You can transfer the data from Access to Excel without too many problems
(either open the table and then use File | Save As/Export... from the menu,
or use the TransferSpreadsheet action in a macro, or method in VBA code).
However, your Access forms and reports won't work in Excel: you'll have to
rebuild any GUI you've currently got from scratch. As well, assuming that
your databases were properly normalized, you'll like want to redesign the
spreadsheets once you've got the data transferred (or create queries that
denormalize your data appropriately, and export the queries, not the
tables).

What is it about your new system that "will not support access"?

 

[Guest]

Thanks, I am a little lost to be honest. The reason the system that won't
support access is a new business network...supposed to be improved, seems
more like a backward step to me.
Wish me luck!

 

[tracy]

I have lots of databases on Access, I need to change them as our new system
will not support access, someone said its easy to convert them yo excel
and
excel can do everything access can...personally I'm not convinced, can
anyone
help?

 

[George Nicholson]

someone said its easy to convert them yo excel and

excel can do everything access can

"someone" has very limited (if any) knowledge of either Excel or Access.
Stop listening to anything they say on the subject, or let them do the
"conversion" for you.