[AccessD] Word Table to text Import into Acess 2003

Hey Susan
When I import into Excel or Access I do indicate that the first row is 
the header. 
If I go into the text file and pull the header information up so that it 
all appears on one line it imports the headers with no problem.

Reference Number %Date %Category %Action %Required  

You may be right, I may have to clean up the converted Word table text 
before I import it.
It may also be embedded characters in the table. Turned on the Show and 
I can see some weird characters. Now I got to figure out what they 
indicate and how to turn them off.

Thank you kindly

Susan Harkins wrote:

>There should be an option for identifying the first row as header when you 
>export and import. As for the rows of data, sometimes you have to clean up 
>the data before you export. Years ago I wrote something on cleaning up Excel 
>data before importing to Access, but I don't know how helpful it would be 
>with Word data. I can try to find it for you if nothing more helpful turns 
>up.
>
>Susan H.
>
>
>  
>
>>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???
>>    
>>
>
>  
>