K Kanga Oct 10, 2003 #1 I have to import a table from word into an access database and I don't have a clue how to start. How do I do it? Taa! in advance.
I have to import a table from word into an access database and I don't have a clue how to start. How do I do it? Taa! in advance.
M MacDermott Oct 10, 2003 #2 I usually do this by copy-pasting it into Excel, then using File - Get External Data - Import Table from Access. HTH - Turtle
I usually do this by copy-pasting it into Excel, then using File - Get External Data - Import Table from Access. HTH - Turtle
M M.L. Sco Scofield Oct 11, 2003 #3 In Word, on the Table menu, you will find Convert Table To Text. Then in Access, on the File menu, you will find Get External Data. Depending on the data in the table, you may have some issues. Take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;290169. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+ Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue Miscellaneous Access and VB "stuff" at www.ScoBiz.com
In Word, on the Table menu, you will find Convert Table To Text. Then in Access, on the File menu, you will find Get External Data. Depending on the data in the table, you may have some issues. Take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;290169. -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+ Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue Miscellaneous Access and VB "stuff" at www.ScoBiz.com
