Updated Input & Output Specifications

[Laura453]

Hi,
I need to update the import / export specs on a database, accessible from the "File --> get external data --> import --> text files --> advanced..."

Everytime I update a spec, and say "Save As", when I re-open the spec my changes are lost and it reverts to the old one.

Furthermore, if the old version of the Import spec is used, it kills off all changes made to the target access table, renaming all fields as per the import spec.

Can anyone shed any light on import / export spec maintenance? can I access the spec file some other way?

Many thanks!
Regards, Lisa.

 

[dhookom]

You may be making changes to the specification but not saving them. You can modify these manually or through code. The specifications are stored in two system tables. To edit, you need to open the tables from a query.

Edit with care.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JerryKlmns]

Lisa,

You could export the MSysIMEXColumns table to excel, do your modifications there for a specific SpecID. Then use code to delete that SpecID from MSysIMEXColumns table
(Press Ctrl+G, type this

CurrentProject.Connection.Execute "DELETE MSysIMEXColumns.* FROM MSysIMEXColumns WHERE SpecID=[b]YourSpecIDNumberHere[/b]",,129

and press ENTER)

and import into MSysIMEXColumns from the excel file with File-->Get External Data-->Import...

BUT you 'll have to know exactly what you are doing especially with the DataType field