0 00KobeBrian Sep 19, 2006 #1 How can I add a column and re-order the column in an existing import/export specification with access97? Thanks.
How can I add a column and re-order the column in an existing import/export specification with access97? Thanks.
D Duane Hookom Sep 19, 2006 #2 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.
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 Sep 19, 2006 #3 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.
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 Sep 19, 2006 #4 You could go through the wizard again and edit the specs or just do it in the query.
0 00KobeBrian Sep 19, 2006 #5 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.
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 Sep 19, 2006 #6 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....
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....