Setting Column headings in an imported text file

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.
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to UN-check greyed-out "First Row Contains Column Headings" bo 0
Importing Text Files Into Access 1
cannot uncheck "first row contains column headings" importing XL2 0
Column headings on an import 6
Importing Fixed Length File into Access 2007 1
CSV Import with duplicate field names 3
Importing an Excel file 4
Importing text file 1

Top