Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-04-2011, 05:46 PM
ibclare ibclare is offline I need help with keeping an inventory organized w/ WORD or Excel? Windows 7 64bit I need help with keeping an inventory organized w/ WORD or Excel? Office 2007
Novice
 
Join Date: Mar 2011
Posts: 12
ibclare is on a distinguished road
Default Hmmm, have you tried ...

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping track of sent items Eugen_Denoes Outlook 8 10-22-2012 04:24 PM
I need help with keeping an inventory organized w/ WORD CeltFan09 Word 1 01-31-2011 06:44 AM
Keeping scores in ppt, please please help piper7971 PowerPoint 0 07-24-2010 07:10 PM
Keeping source formatting in Word 2003 texoz Word 0 06-30-2009 07:45 AM
I need help with keeping an inventory organized w/ WORD or Excel? Help please: Keeping spaced characters on one line EtienneOBrien Word 3 12-24-2008 07:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft