importing tables into Access, why can't I adjust field options

E

Eduman

When importing tables into Access, as I go through the wizard, I come to a
screen that supposedly allows you to click on the field name, indicate
whether the field is indexed and allows or not allows repeats, and skip the
field altogther. I can't get anything to take after the first column. If I
try to change any properties in the field option box, it applies it to the
first column only. Is this a glitch or is there a keystroke that makes it
work? I'm using Access 2003.
 
J

John Nurick

Hi Eduman,

You don't say so, but I presume you're importing data from text files.

As far as I can remember the problem you describe existed in the
original version of Access 2003 and was fixed in a service pack. Have
you installed the current service packs?
 
E

Eduman

Apparently not. I'll have to get with my IT department as they have blocked
us from downloading or installing any software.
 

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

|9 can't find the field '|' Error when importing a csv to Access 2 1
Importing from Excel to Access 1
Import an outlook contact list into access 2007 0
Import errors importing Text into existing table, header vs no hea 3
Importing excel into access 2
Import an Excel yes/no field 1
Importing from Excel to a lookup field in access 6
Import Wizard dropping fields defined by Import Spec Access 2007 4

Top