Import Spec Modification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there no other way to modify import specs except by going through the
import process? Why isn't there a more direct route like a menu item? Has
anyone ever added a menu item for this, can it be done?
 
You can manually edit the specs in a query like:
SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;
You can do something similar with MSysIMEXSpecs.

This isn't recommended since you can really mess up some values. The wizard
interface protects you from mucking things up.
 
I can see the data in MSysIMEXSpecs and MSysIMEXColumns but there is no way
I can figure out to modify the data ..anybody know a way (code?) to do that?

Bob
 
Did you try create a query and view its datasheet view? You can modify the
records in these tables with code. I'm not sure if anyone has a sample on the
web of how to do this but it shouldn't be that difficult.
 
Duane

Initially I tried using a query that joined the tables and that did not
allow modification..however, I tried again using a query based on one table
and damn if it did not work! Thanks

Bob
 
You probably tried to do the obvious and join on SpecID. I don't understand
why MS didn't make this Autonumber field the primary key of the specs table.
Maybe it was to keep us from editing queries with the two tables :-(
 
Back
Top