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?

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"?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"dizzyblond" <(E-Mail Removed)> wrote in message
newsC7AB865-6D6B-4DF6-A2FD-(E-Mail Removed)...
>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?

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!

"Douglas J. Steele" wrote:

> 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"?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "dizzyblond" <(E-Mail Removed)> wrote in message
> newsC7AB865-6D6B-4DF6-A2FD-(E-Mail Removed)...
> >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?
>
>
>

"dizzyblond" <(E-Mail Removed)> wrote in message
newsC7AB865-6D6B-4DF6-A2FD-(E-Mail Removed)...
>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?

> 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.



"dizzyblond" <(E-Mail Removed)> wrote in message
newsC7AB865-6D6B-4DF6-A2FD-(E-Mail Removed)...
>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?