Saved Imports (1 Viewer)

[Skip Bisconer]

Is there a way to run a saved import of tables through VBA? Or must I do a separate import for each table?

 

[Pat Hartman]

You can use the TransferText, TransferSpreadsheet, TransferDatabase methods in VBA or in macros. If you needed to create an import specification, save the spec and you can reference it in the TransferText method.

If I were feeling lazy, I might do this with a macro if it were just for me but normally, I would do it with VBA which in this case would be just as easy due to the availability of cut and paste.

 

[Skip Bisconer]

Thanks Pat,

I found a docmd.deleteobject actable, "tablename" which seems to work and then I ran DoCmd.RunSavedImportExport "SavedImportName". I should have checked it out before I posted.

 

[krishan.chawla]

hi..

How can i delete import/export specifications in access 2003

 

[Pat Hartman]

I don't know of a way to delete them. If you really want them gone, create a new database and import all the objects except the import/export specs you want to leave behind.