Software

Ask something
Discussion Locked

Access 2K-can't save import specs

0 helpful
7 replies

by athaena

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In MSAcess 2000, we are unable to modify,create or save import specs for ascii files. Old specs are accessible, but new fields cannot be added. Why?

7 replies

by kees.valkenswaard

The system just works different. You can add yourself fields in the list of field data at the bottom of the import/export specification [which appears to be just an example].
Once you have made changes there, it is possible to save the spec.
Good luck

by athaena

Yes, I know it works differently. I have added to the list and saved and the entries are tossed when clicking on the SAVE option.
The question is HOW DO YOU SAVE OR CREATE NEW SPECS?

by kees.valkenswaard

Once I have made a new import/export spec [under advanced..] I can save it with save as? and use it the next time again for a subsequent import or export. The only thing I am not able to do is to use the spec in another database as it seems to be part of the data base in which it has been created.
The Help file suggests that there might be a way to use schema.ini in VBA code, where schema.ini is in the same directory as the current database. I did not find yet any details how to create such a schema.

by athaena

Thank you, Kees. I am unfortunately still unable to modify the spec within the original db and import using the same input structure.

This discussion is closed to new replies.