Question Inserting Field into Import Specification

[whdyck]

I'm using Access 2003.

Probably a dumb question, but if I create an Import Specification, how do I add an extra field in the middle of the field list? All I can see to do is re-enter all fields from the new field downward.

Thanks for any help you can give.

Wayne

 

[JLCantara]

Hi,
I'm not sure to understand what you realy want:
1 - If it is during the import process, I never heard of any structural table modification (but who knows...).
2 - If it is after the import then use, in design view, the insert lines button.

JLCantara.

 

[whdyck]

Hi,
I'm not sure to understand what you realy want:
1 - If it is during the import process, I never heard of any structural table modification (but who knows...).
2 - If it is after the import then use, in design view, the insert lines button.

JLCantara.

Perhaps you're using a different version of Access. If, while creating the spec, I forget a field, I see no way to insert it between two existing ones. (I'm trying to do this looking at the form as in the attached.)

No problem if it's a small table, but if it has 100 columns and I forget something at the beginning, it's painful.

I'm resorting to intentionally adding a blank field every so often so that I can just delete the extras at the end. That's better than redoing most of it. But I thought there should be a better way.

Thanks.

Wayne

 

[JLCantara]

Hi,

Your using Access 2010 ?

Anyway, I tough of a Sherman type of solution.

Make a copy of the Import description.

Open the original file and proceed with the addition manualy: you will easily find a repetitive block that defines the fields. Don't be impressed by the format: it's probably XML or a fancier format.

Then, give it a try...

JLCantara.