Modifying an import specification

[ronzul]

Hi there

I am using Access 2007 to import a number of different text files with the import wizard.

As the files are complex, it might take a few attempts to get the specification correct.

if i attempt the import and there is an error, i do get the option to save the import specification.



From "Saved Imports" i can later rerun an import using an existing specification, but i cant see how to edit an existing specification.

Any ideas?

Many thanks

[dcrake]

Don't know about 2007 but when you do a manual import and select the import spec using Advanced you can then make the changes to the import spec and click Save. You can then refer to the import spec in your macro or vba and it will use the revised version.

David

[RuralGuy]

Bob Larson has some pictures of the operation.
http://www.btabdevelopment.com/main/...9/Default.aspx

[ronzul]

Great, thanks to you both