If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks. |
#2
|
|||
|
|||
import/export specification
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. |
#3
|
|||
|
|||
import/export specification
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. |
#4
|
|||
|
|||
import/export specification
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. |
#5
|
|||
|
|||
import/export specification
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. |
#6
|
|||
|
|||
import/export specification
|
Thread Tools | |
Display Modes | |
|
|