import/export specification

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
 
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.
 
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.
 
You could go through the wizard again and edit the specs or just do it in
the query.
 
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.
 
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....
 
Back
Top