Discussion Locked

MicroSoft Word to access to excel

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to transfer Microsoft Access to Microsoft Excel or Microsoft Word? or as
a text file...how do I do this.

9 replies

by highlander718

If you mean a table from Access you can do it easily from Excel where you have the option Get external data under Data menu . If you mean a Report from Access you can try to print to file but but better use the query on what the report is based (or table) and import it to Excel with the same option.

by dklippert

Go to File>Save As/Export. Choose ?To an External file or Database?. Change the ?Save as Type? to either Excel or Microsoft Word Merge (TXT file).
If you want to send a report to Word, Open the report in Preview view and choose Word from the Office links button on the toolbar. This will convert the Access report to a Word .RTF document.

by robert_kinney

YOU CAN OPEN THE TABLE AND GO TO FILE SAVE AS EXPORT AND CHOSE TO SAVE AS A TEXT FILE. THEN YOU CAN OPEN THE TABLE IN ANOTHER APPLICATION. I AM NOT SHURE WHAT YOUR ARE DOING YOU MAY WANT TO LOOK INTO IT BECAUSE THEIR IS A LOT YOU CAN DO IN ACCESS ITMAY BE EASIER TO USE ACCESS RATHER THAN WORD OR EXCEL.

by jason kiner

If you are trying to edit the results of a report, you might try going to Tools > Office Links > Publish to Word or Analyze with Excel

This discussion is closed to new replies.