import/export specification

0

00KobeBrian

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

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.
 
0

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.
 
D

Duane Hookom

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

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.
 
A

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....
 
Top