View Saved Import

[LadyDi]

Is there any way to view a Saved Import to see what it is doing?

I just inherited a database from someone that has several saved imports. I need to be able to see where the data is coming from and where it is going to so that I can recreate it using VBA.

 

[Pat Hartman]

Look for TransferSpreadsheet or TransferText in the code. That is most likely how the data is being imported. You can find the source by following the trail to that code or the source may even be hard-coded in the Transfer statement.

 

[LadyDi]

They didn't do the import via VBA. They have a Saved Import and use macros to run it. All the macro says is to "RunSavedImport" and the name of the import, but nothing else.

 

[Pat Hartman]

In newer versions of Access I don't think there is any way to directly open an inport/export spec (although you can probably examine the MSys table that holds them). If you want to look at it, start the import manually, then press the advanced button as soon as you see it. Choose the spec name from the list. That should show the record layout of a fixed format file.