Converting Access info to text

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

prpliris

Thread Starter
Joined
May 7, 2007
Messages
36
I am transcribing a cemetery to put the info on the web and it has to be in text format.
I have the database while I am working on gathering data, taking photos, etc in Access. Is there any way to take the info I have in Access in output into plain text format.
Its okay if I lose the formatting - just having the data will help.
The output format is required to be in columns, i.e., name, birthdate, death date, epitaph.
I sure hope someone can help with this. I have tried taking it to Excel and then outputting and nothing gives me a plain text format.
Thanx :) G
 

OBP

Joined
Mar 8, 2005
Messages
19,895
You can use the Main menu option File>Export to export your Table of data.
You can choose either .RTF (Rich Text Format) or .txt (Text Format)
the text format option outputs in columns but encloses the data in quotes when viewed with wordpad.
 

prpliris

Thread Starter
Joined
May 7, 2007
Messages
36
Hi
I did this and there was no choice for .rtf and plain text. The output is in an Excel looking format with bars or dashes. Anyway to get rid of that??
 

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
You outputted as a CSV or comma separated values file which will automatically open up in Excel. Are you exporting a table or report?
 
Joined
Oct 10, 2007
Messages
33
BTW, the option to choose the file type doesn't appear until you see the window "file save" box -- then you can select from a bunch of different formats including excel and html as well as RTF and text. You will need to think about where you want the data -- in tabs, with a space in between, with a semi-colon... If you put it into excel, you can use =concatenate function to put the fields together how you like and then copy and paste the resulting cells into a document application like notepad, wordpad or word.
lika2know
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top