Setting Column headings in an imported text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just updated to 2003. Have imported text files, fixed width with break lines. Won't let me name column headings. Keeps changing the Field 1 only.
 
This is a known BUG.
Not sure if it is in MSKB yet but it has been confirmed by MS.

There is a simple workaround.
Before you click Finish, be sure to click Advanced and Save As...
Give the spec a name.
Now you can edit the file names on this screen as well as positions and
datatypes.
Be sure to save your changes.
--
Joe Fallon
Access MVP



FMC said:
Just updated to 2003. Have imported text files, fixed width with break
Click to expand...
lines. Won't let me name column headings. Keeps changing the Field 1 only.
 
Back
Top