View Single Post
 
Old 05-04-2011, 05:46 PM
ibclare ibclare is offline Windows 7 64bit 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