473,324 Members | 2,214 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

converting MS Word document to MS Access?

Hello--

I'm new here, and with using MS Access. I have a list of addresses that's
now in MS Word, and it would be easier for me and the person I'm going to
give this address list to, to be able to have the address list in MS Access.

Is there a way to import these addresses into MS Access--and thereby not
have to type them into the program--being able to do this would save a lot
of time and work!

Thanks in advance,

Jean in VA
Nov 13 '05 #1
2 1263
Jean,
that's sort of a loaded question. The whole thing entirely depends on
how "normal" your address list is. In other words, is the first line
*always* the recipient's name? the second the address, the third the
city/state/zip code?
What I'm getting at is that you're probably going to want to break
these addresses up some way in order to do something like send a letter
to a subset of the entire group. In that case, you may need to parse
them. And that could get fun. If they're perfectly consistent, then
it's fairly easy. You could save the file as a text file and read a
line at a time and break it up that way.
Not much of an answer, I know, but the answer is somewhat "It depends
on how your data is formatted etc".

Nov 13 '05 #2
Jean,
Maybe. Access likes things a certain way. It helps if the first row is the
name of the column. It helps further if the character marking the beginning
and end of each column is something Access can recognize like a tab
character. Third, it's less confusing for Access if big text columns begin
and end with double-quotes. All of this is stuff that can be done quite
quickly in Word to get things ready. Once the information is tab delimmited
in nice columns Access should have no problem importing it.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"Jean S. Barto" <js******@cox.net> wrote in message
news:PSa7e.4982$ka3.4382@lakeread02...
Hello--

I'm new here, and with using MS Access. I have a list of addresses that's
now in MS Word, and it would be easier for me and the person I'm going to
give this address list to, to be able to have the address list in MS
Access.

Is there a way to import these addresses into MS Access--and thereby not
have to type them into the program--being able to do this would save a lot
of time and work!

Thanks in advance,

Jean in VA

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
by: Davinder | last post by:
can anyone recommend a good tool to convert documents to HTML on the fly. I need to integrate this tool with a VB app so it must have an API. thanks in advance Davinder davinder@gujral.co.uk
20
by: Al Moritz | last post by:
Hi all, I was always told that the conversion of Word files to HTML as done by Word itself sucks - you get a lot of unnecessary code that can influence the design on web browsers other than...
8
by: prabha | last post by:
Hello Everybody, I have to conert the word doc to multiple html files,according to the templates in the word doc. I had converted the word to xml.Also through Exsl ,had finished the multiple...
4
by: Jeff Harbin | last post by:
I've got an ACCESS 2000 application that I'm developing. One of the outputs of this app will be to generate a series of 'jobs' which corresponds to a record in the database. Each record will be...
4
by: Otis Hunter | last post by:
I have been given an Access Database which contains a table that has an OLE object field that contains a Word document. That table contains hundreds of records. I would like to find out how I can...
4
by: svdh2 | last post by:
Dear All, I have lately strugled more and more with Access, what started as a simple database has brought me to the fundaments of Access. I need to transfer fields from various tables to a...
8
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...
0
by: dotNetDummi | last post by:
Hi experts, I have a task to print some data into a word document .I need to set the word document to readOnly. It's working but user still can edit. Is there any thing I can do whereby user...
5
by: sphinney | last post by:
Basic question: Does anyone know how to go about adding a control to an Access 2007 form that will allow viewing a Word 2007 document? Reason for asking: My office is about to receive 100+/-...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.