Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Transpose date?
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! |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Transpose date?
SHOULD BE TRANSPOSE DATA.....sorry!
"detobias" wrote: 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! |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2002: Macro w/today's date - update date automatically | Microsoft Word Help | |||
MULTIPLE ROWS IN TRANSPOSE | Microsoft Word Help | |||
shortcut key to transpose | Microsoft Word Help | |||
macro to transpose characters | Microsoft Word Help | |||
Can I Transpose a Word table? | Tables |