import/export specification

[00KobeBrian]

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

 

[Duane Hookom]

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.

 

[00KobeBrian]

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]

You could go through the wizard again and edit the specs or just do it in
the query.

 

[00KobeBrian]

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.

 

[Albert D. Kallal]

Build a query with the correct fields you want in the correct order in the
grid.

Then invoke the export wizard on that query...you find this much easier....