Microsoft Office Home and Student

[phil_hg_uk]

In that case just export it to a CSV file (Comma Separated Values) making sure you tick the make first line name of fields box (or whatever it says) then just use the import into excel making sure you tick the first line is name of fields and bingo job done

 

[Speicher]

Is that it?

Will that also "re-set" the auto fill id thingy or whatever it is called?

It is very kind of you to give me all this help.

 

[phil_hg_uk]

Not sure what you mean by the auto fill id, do you mean record numbers if you do a spreadsheet has row numbers already.

if the spreadsheet solution would be suitable or not really depends on how you are viewing and using the data, if you using it to populate an access custom form for instance where you put in a value into a box then so a search for it then it wouldnt work, but if you are just using it as a lookup table or something like that it should be ok.

 

[Speicher]

Currently there are about 620 books. If I want to add another book, I have to put the ID of the books in numerical order. Then manually give the next book the next number. I call it the ID because that is what the title of the column is.

In auto fill ID, (the record number ?) when you add a book, and you put the cursor in the ID column, it automatically gives you the next number, even if all the books are in alphabetical order.

We would do two sorts of searches, either all the books in a particular category, or search for a particular title or author. Nothing ever so complex. Your second paragraph is difficult for me to understand.

 

[phil_hg_uk]

Ah right I see how you are using it.

A spreadsheet is great for listing things, for instance part of what I do is running a website hosting business and I use a spreadsheet to list domain names and hosting accounts against a customer name and I also have a column that shows costs etc the problem is a spreadsheet is not great for searching though and rearranging data into a particular way.

What I would be tempted to do is do a google search for free database applications you might even checkout google apps I cant remember if they do a database.

I wouldnt shell out for access when you are using it for such a small application its not worth it when I was using access and programming SQL databases I was using data with 1,000,000 + items, remember if you export the data as a CSV you can import it into any database application you want as they should all understand CSV files.

 

[Speicher]

Yes, it is a comparatively small database.

I will keep it in Access I think.

Thank you for all your help.