Table from Word to Access

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a table in Word with a lot of names.
How may I translate this in Access keeping the same position of the names
like is now in Word once I get the report with Access.
The report or the form of the database should match the table done in Word.
For example:
---------------------
| A1 | B1 | C1 | D1 |
---------------------
| A2 | B2 | C2 | D2 |
---------------------

Does this question make sense or am I on the wrong way?

Thanks for Your help and cooperation.
Kind regards
John
 
Is this a one time thing? If so, select the table including the column
headers then copy and paste it into a new Excel workbook. Name and save the
workbook then use File-->Get External Data-->Import to import the worksheet
into a new table. The import wizard will recognize and attempt to use your
fieldnames.
 
Hi Sandra,
Thanks for the infos.
I have a total of 40 Word files. Each file has 4 column and 7 rows.
I would like to use access, to create a better and structured application.
The only "must" is that I have to follow the orizontal and vertical order as
it is in Word. And to be onest I haven't any clue where to start.
Thanks again.
John


Sandra Daigle said:
Is this a one time thing? If so, select the table including the column
headers then copy and paste it into a new Excel workbook. Name and save
the workbook then use File-->Get External Data-->Import to import the
worksheet into a new table. The import wizard will recognize and attempt
to use your fieldnames.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a table in Word with a lot of names.
How may I translate this in Access keeping the same position of the
names like is now in Word once I get the report with Access.
The report or the form of the database should match the table done in
Word. For example:
---------------------
---------------------

Does this question make sense or am I on the wrong way?

Thanks for Your help and cooperation.
Kind regards
John
Click to expand...
Click to expand...
 
Back
Top