Import Specification

[dbero]

I have created several import specifications I use to import data. I now need to modify them. Is it possible to update the specification without having to manually start the import process and then select that specific specification?

I would like to get to the specification directly rather than having to fake an import.

Thank you.

 

[dhookom]

I think you can edit/update the column definitions in a query with SQL of

SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;

Duane
Hook'D on Access
MS Access MVP