[78-L] 78s spreadsheet Excel vs. Access-thoughts on these?

[David London]

First criteria for ANY system you pick, is the ability to import/export
data.  You will spend a lot of hours putting data into the system, and you
don't want to lose the data in the future.  You may want to use the data
other ways, or from other systems.  Maybe the solution you choose will
become obsolete.  Therefore, always be able to move on to a new system.

I started years ago with my records cataloged in custom databases, dbase,
then access, and now in mySQL.  The most often used medium to transfer data
is via a SQL query, or at worst case, via a .csv file.

As you say, you can transfer data from Excel to Access, and from there, even
on to Microsoft's SQL server.


On Sat, Mar 20, 2010 at 7:06 AM, <victrola78s at aol.com> wrote:

> Thanks for responding, fnarf & Gene. I would certainly welcome a few
> pros & cons of the two systems(briefly, I suppose-don't want to annoy
> fellow 78-listers). Before I get too much deeper into this I'd better
> be sure of how to proceed:) My understanding is that data from Excel
> can be transferred to Access, or vice verse. Any tips would help a
> great deal. Thanks!
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>