Edit Import Specification in Access 2007

[annie52]

Is there any way to view/edit saved import specs in 2007? I had a number of import specs that imported xls files quite nicely but now we have to import xlsx files. I re-wrote them and they worked just fine yesterday. Today, I'm getting error 3011. The file is exactly where it should be so I don't get it. I wonder if my code is cranky:

DoCmd.RunSavedImportExport "Import-MilstripOpenHistory"

 

[dhookom]

In earlier versions of Access, you could create queries based on the msys tables with the import/export data. These queries would allow you to edit the records directly. I typically don't recommend you mess with these unless you backup your files and understand what you are doing.

Duane
Hook'D on Access
MS Access MVP

 

[annie52]

Yes, I knew that. Actually, now I'm not sure whether the 3011 error refers to the spreadsheet I want to import or the destination table. I just realized the table was missing so I imported a backup copy and tried to run the import specification again. I got the same error and the table is missing again.

I understand that the table is supposed to get deleted before the data is imported. But, I'm not sure at what point that happens. Any thoughts?

 

[dhookom]

I'm confused since I am not aware of any deletion or whatever.

Duane
Hook'D on Access
MS Access MVP

 

[annie52]

I just discovered that the owner of the external spreadsheet made changes to it that affected my import specification. Wow! Let's hear it for internal communication. I re-wrote the spec and am good to go now. Thanks for taking this trip with me.