Importing text file

G

Guest

I'm a long-time user of Access 97. I have just received Access 2003 and I
have a small issue with importing text files into new tables. These are
Fixed Width files and I establish the appropriate break lines, then the next
step is where the issue resides . . . with the exception of Field1, the
field names cannot be changed on this screen. No matter which field I
highlight, the first field name is always displayed. This forces me to
select Advanced, which is a work-around, but seeing the data is often
beneficial in assigning a proper name. Is this a bug in 2003?
 
J

John Nurick

Hi Will,

IIRC it's a bug in the original Access 2003. If you install the latest
Office 2003 service pack it should fix it.
 

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

Importing Text Files Into Access 1
Import Trailing Spaces 8
Importing text file 1
Importing Fixed Length File into Access 2007 1
Import files into access 1
importing multiple lines of text into a field in table 1
Import errors importing Text into existing table, header vs no hea 3
Import Text File with Import Spec 3

Top