Can fields in system table be accessed for editing somehow?

  • Thread starter Thread starter djh
  • Start date Start date
D

djh

I need to modify the import specifications stored in a
database, so that the first row is not skipped. I do not
see this field when I pull up the saved specs from the
Advanced tab of the Import Text Wizard. I know that it
is the StartRow field in the system table, MSysIMEXSpecs,
but I am unable to change the values there. Any ideas
other than re-entering all the specs again.
 
It's really not recommended that you update the system tables directly, even
in those rare cases where it's possible (most, if not all, of them are
read-only).
 
in this case it is possible though, but you have to use an update query

HTH

Pieter
 
Thanks. That was easy, and much, much quicker than
reentering the many field specs into the import text
wizard.
 
Back
Top