View Single Post
  #3   Report Post  
marc
 
Posts: n/a
Default

Hi Beth -

Thanx for the quick reply!!!

What I did was copied and pasted a blank (dataless) word table into an
access report...I then built that report (with data) in access, then tried to
export it back into word and that's where I've run into this issue....Like
you mentioned, it's just exporting the access data, nothing else...I also
recreated one of my word tables in access (built the columns and rows and
text so it would mirror the word doc), yet still access would only export the
data into word, not the column/row lines....

It's an educational report that I need to complete soon...There's about 10
different tables and about 1000 unique fields in each report...There's a
total of 30 reports that I need to complete, one for each city...Each report
is formatted the same, only the student data will differ for each city...

I've been able to export the data (not the formatting) by the 'publish it
with word' command and then copy and paste it into each row of one of my
original word tables from there...This just seems like a ton of work and
there must be a quicker solution....I'll also mention that I tried a
mailmerge with no luck....

Thanx in advance if you can help me out,
marc

"Beth Melton" wrote:

I'm not exactly following what you are trying to do. Access Reports
are designed for reporting on data stored in Access. If you
copy/pasted a Word table directly into an Access Report then you
simply placed an embedded Word table in the report and it isn't bound
to the database.

When you export an Access Report you are not exporting what you see on
the screen. The data placed in Access controls, such as text boxes and
labels, is what you are exporting and it doesn't include embedded
objects.

Perhaps if you can expand on what you are attempting to accomplish we
can provide some suggestions.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"marc" wrote in message
...
I have a report written in word that contains a number of tables....I
copied
those tables into access reports and got the data to line up
accordingly
using access...I then went to export the tables (with the data) back
into
word and the only information that was exported was the data from
access....The rest of the page was blank...

Is there anyway to keep the tables formatted and displayed when
exporting
into word???

I've tried a number of different solutions, including recreating the
tables
and exporting to different file types with no luck....I also tried
to do a
mail merge, but I've run into limitations due to the number of
columns....It's a substancial report and, of course, it's due by
Friday
(31)....

Any help would be hugely appreciated!!!!!
marc
btw - I can access all of the versions of office, 97, xp, etc...