I tried to go to the wizard again but somehow I cannot add an extra field
and put it in the right order in the spec. Do you have any guideline?
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You could go through the wizard again and edit the specs or just do it in
the query.

--
Duane Hookom
MS Access MVP

"00KobeBrian" wrote in message
...
Thanks for the information. This seems a bit complicated because I need
to re-adjust the startid and width for every column. Is there an easy
way.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You can try create a query with SQL view of
SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;

You may have success modifying the records in the query but you must be
very cautious.

--
Duane Hookom
MS Access MVP

"00KobeBrian" wrote in message
...
How can I add a column and re-order the column in an existing
import/export specification with access97? Thanks.