So I am keeping an inventory using WORD at the moment. The inventory consist of sports cards, categorized by sport -> year, and then each card is tagged with an attribute [AU] = autograph, [Jsy] = Jersey etc. In Word I use it to just keep a long list of everything. I Add & Remove constantly as I am always buying/selling/trading. Now the thing is, I have a website where each sport has its own page with a sub page for each yeah. Everything is a mess and I know I am going to get mixed up somewhere sooner or later. I need help getting organized. If someone wants to see my WORD Inventory and my site, PM me. I could use any help getting this mess organized.I am coming to conclusion that Excel is probably my best bet to keep it organized? But my list in word is very sloppy, only thing that is going to suck, is when I have to copy and paste from WORD/Excel to 16 different pages each time I have to update...

Hi
If you have not had any help yet then please send me a copy of your files to OTPM@BLUEYONDER.CO.UK and tell me exactrly what you are trying to achieve and I will see if I can help.
OTPM

I'm not exactly sure what you're trying to convert. If it's in table format, you can change it to a comma separated format (table tools, layout, data, convert to text).

Choose comma separated or tab, etc. I've only used comma separated. This can be imported into Access (or Excel) as a text file. Access is a great database format for what you're trying to do, I think. If it's not in a table, I think you can create your own delimited file putting in commas, tabs, etc. If so, save as text file or select all and copy into notepad.

I have had problems with the save as rtf; not sure why access doesn't see this as a text file. So I've done select all and saved in Notebook. Might be that your document is too long for notebook (I can't remember the limitations), but maybe somebody has a fix for the file format; or maybe you have another text editor program you can use. So, if you go this route, remove the headers as you'll type those into the wizard yourself.

Anyway, open Access, go to External Data and choose text file, which will open a wizard: browse for file, leave default "import into new table" checked; next "delimited;" next choose delimiter; next type in a field name - don't click next yet; click on next column to highlight then type in name, etc.; next probably use default for primary key if you want every item to have a unique number (o/w choose no primary key), next, name your table and click finish. Sorry if I'm over doing the step by step.

Excel's wizard is actually shorter: select data tab, external data, text file. Easy. Getting your doc prepared is probably the most work. You can create headings if you want, then create a table with headers.

Anyway, those are a couple thoughts depending on what you need to accomplish. Good luck.