Tony Septav
iggy at nanaimo.ark.com
Sat Jan 26 08:44:23 CST 2008
Hey All
I have an inherited Word Table that I would like to bring into Access
2003. I have followed the intructions of selecting the table and then
converting it to text using a % delimiter character (checked table
data no % used whereas commas are used in the table) and saving it as a
text only file.
When Word converts the table to text, the format is kinda of goofy.
Simple example
Word Table column headers are converted to
Reference Number% Date
% Category % Action % Required %
When I try to import it into Access or Excel I get column headers
Reference Number Date
Category Action Required being
the first row of data
1 July 31/07
being the second row of data
It gets worse with the text in the rows. I can manually go in and fix
the text file.
I have not done this before I am missing something obvious here???
Thanks