Import Specs A2007

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I have a new import spec I've tested in a sandbox and now I want to import it
to my production fe (A2007). I did the usual import wizard, selecting "Import
Specifications" from the advanced menu and clicked OK. Well, first it popped
up a message telling me it couldn't find a key of some sort. Then it told me
one or more of my specs was alredy in my production table...true.

Then if failed to import any specs. I checked the msysIMspecs table and it
has a couple odd entries, but I don't want to delete them willy-nilly. They
have no spec name...look like erroneous. Still, my other specs are there, and
look just fine.

Should I try deleting the "unnamed" specs and then try again? Can I manually
link to the other db's msys tables and then append the appropriate rows?
Ideas?
 
You can use a query to append records from the system tables MSysIMEXSpecs
and MSysIMEXColumns in one database to the other database.

- Steve
 
Back
Top