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

[Gene Baron]

Another thought, and I also do this a lot at work, is to add a fake line as
the first data line in your Excel filre and make it all text, a,b,c,d --
that sort of thing, and then Access will import it as text and not drop
leading zeros.

Gene

On Sat, Mar 20, 2010 at 12:00 PM, agp <agp2176 at verizon.net> wrote:

> I have been trying to enter my collection into Access for a while. I
> do about 5 entries a day.
>
> You can import data for Excel directly from .xls file or from a saved
> .csv file. The benefit of the .csv file is that Access may try to
> change things that look like number into numbers, but you may want to
> treat as text -- like catalog numbers. When you do an import from a
> .xls file you cannot change the data type as is it imported. Any
> catalogue numbers like 05627 will drop the leading zero. You can do
> this if you import from a .csv.
>
> I do this sort of stuff in my work at my day job :-)
>
> That said, while you can do lotsa cool things with Access, basically
> because you write the stuff yourself, its a pain in its own way. I'd
> like to find a good 'free' piece of software for record collectors
>
> T
>
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>