Thread: Transpose date?
View Single Post
  #3   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 Transpose date?

If you have to do this multiple times as you indicate, it would be best to
develop some code that iterated through the rows of the table of each
document and transferred the information into the relevant fields of a
record that it added to a table in the database for each document.

See the following page of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Extract_Form_Data.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

"detobias" wrote in message
...
I am taking data from a short survey in a word table and copying it into an
Access DB.....the data is vertical in a word table and I want to make it
horizontal to transfer it to Access. Is there any way to
copy/paste/transpose as there is in Excel? Or will I need to copy into
excel, transpose then copy into Access? There will be many surveys since
it
is from emails. Any help appreciated!