Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
megadari megadari is offline
external usenet poster
 
Posts: 5
Default Question about exporting Word table to Access

I have a Table in Word 97 where the cells are formatted like a sheet
of labels, and it is used to enter contact information from a internet
voice mail system. This was an existing set up when I started. I would
like to get the data into Access 97. Once a sheet is done it is sent
directly to the printer to be printed on a sheet of labels.

The data is in the cells like this:

First Name Last Name
Address
Address 2
City, State Zip

I have tried exporting but in the text conversion it goes by rows so I
end up with all the names on the first row, addresses and not in fixed
width format. Any suggestions on how I could get these into an
exportable format for an Excel 97or Access 97 import?

Thanks,

Pat
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Question about exporting Word table to Access

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"megadari" wrote in message
...
I have a Table in Word 97 where the cells are formatted like a sheet
of labels, and it is used to enter contact information from a internet
voice mail system. This was an existing set up when I started. I would
like to get the data into Access 97. Once a sheet is done it is sent
directly to the printer to be printed on a sheet of labels.

The data is in the cells like this:

First Name Last Name
Address
Address 2
City, State Zip

I have tried exporting but in the text conversion it goes by rows so I
end up with all the names on the first row, addresses and not in fixed
width format. Any suggestions on how I could get these into an
exportable format for an Excel 97or Access 97 import?

Thanks,

Pat



  #3   Report Post  
Posted to microsoft.public.word.tables
megadari megadari is offline
external usenet poster
 
Posts: 5
Default Question about exporting Word table to Access

On May 16, 1:57*am, "Doug Robbins - Word MVP"
wrote:
See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels...mail_merge.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"megadari" wrote in message

...



I have a Table in Word 97 where the cells are formatted like a sheet
of labels, and it is used to enter contact information from a internet
voice mail system. This was an existing set up when I started. I would
like to get the data into Access 97. *Once a sheet is done it is sent
directly to the printer to be printed on a sheet of labels.


The data is in the cells like this:


First Name Last Name
Address
Address 2
City, State Zip


I have tried exporting but in the text conversion it goes by rows so I
end up with all the names on the first row, addresses and not in fixed
width format. *Any suggestions on how I could get these into an
exportable format for an Excel 97or Access 97 import?


Thanks,


Pat- Hide quoted text -


- Show quoted text -


Thanks!

Pat
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting from MS Access to MS Word - maximum number of characters JE Microsoft Word Help 1 October 23rd 07 05:18 PM
Exporting a table into Access2003. Frank Martin New Users 3 October 13th 06 02:31 PM
Problems exporting access to word Leroy Microsoft Word Help 4 October 18th 05 12:44 PM
Exporting the Dimensions of a Table Cell across Applications Rich Moore Tables 2 June 15th 05 06:48 PM
FORMS GURU LEVEL QUESTION -Exporting FormField info to a SQL Datab BigWylie1 Tables 2 April 30th 05 04:06 AM


All times are GMT +1. The time now is 08:12 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"