Import Specifications Start Row

[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.

 

[Joe Fallon]

You can change data in those tables.
Just write a query on them.
The query is editable even though the table is not.

 

[djh]

Thanks! That was a simple solutin that worked great. I
thought that since the table wasn't editable that I
wouldn't be able to change the values through an update
query either.