Saved Import Access 2007

[davjoh123@yahoo.com]

I have saved an import and it works great. I would like to be able to
start the saved import from a button on a switchboard. I tried using
TransferText and the saved import name but it does not recognize the
saved name as an import specification.

Thanks for any help

[Larry Linson]

Re: Saved Import Access 2007

In some earlier versions of Access, if you save too early in a manual import
process, the Import-Export Spect may not reflect all (or any) of the changes
you made. Try importing, creating the specification, and saving at the very
end of the import process. As I am not in a position to test in Access
2007, it would be helpful if you would post your results back to this
message thread.

Larry Linson
Microsoft Office Access MVP


<davjoh123@yaho o.comwrote in message
news:2ac954af-8f0f-4a72-a428-d1e30ca1ea66@p3 9g2000prm.googl egroups.com...

>I have saved an import and it works great. I would like to be able to
start the saved import from a button on a switchboard. I tried using
TransferText and the saved import name but it does not recognize the
saved name as an import specification.
>
Thanks for any help

[davjoh123@yahoo.com]

Re: Saved Import Access 2007

On May 11, 11:42 pm, "Larry Linson" <boun...@localh ost.notwrote:

In some earlier versions ofAccess, if you save too early in a manualimport
process, theImport-Export Spect may not reflect all (or any) of the changes
you made. Try importing, creating the specification, and saving at the very
end of theimportproces s. As I am not in a position to test inAccess2007, it would be helpful if you would post your results back to this
message thread.
>
Larry Linson
Microsoft OfficeAccessMVP
>
<davjoh...@yaho o.comwrote in message
>
news:2ac954af-8f0f-4a72-a428-d1e30ca1ea66@p3 9g2000prm.googl egroups.com...
>

I havesavedanimpo rtand it works great. I would like to be able to
start thesavedimportf rom a button on a switchboard. I tried using
TransferText and thesavedimportn ame but it does not recognize the
savedname as animportspecifi cation.

>

Thanks for any help

I am using Access 2007 and am saving the import at the end of the
process

[davjoh123@yahoo.com]

Re: Saved Import Access 2007

On May 11, 11:42 pm, "Larry Linson" <boun...@localh ost.notwrote:

In some earlier versions ofAccess, if you save too early in a manualimport
process, theImport-Export Spect may not reflect all (or any) of the changes
you made. Try importing, creating the specification, and saving at the very
end of theimportproces s. As I am not in a position to test inAccess2007, it would be helpful if you would post your results back to this
message thread.
>
Larry Linson
Microsoft OfficeAccessMVP
>
<davjoh...@yaho o.comwrote in message
>
news:2ac954af-8f0f-4a72-a428-d1e30ca1ea66@p3 9g2000prm.googl egroups.com...
>

I havesavedanimpo rtand it works great. I would like to be able to
start thesavedimportf rom a button on a switchboard. I tried using
TransferText and thesavedimportn ame but it does not recognize the
savedname as animportspecifi cation.

>

Thanks for any help

I went looking for the MSysIMEXSpecs table to verify that the import
spec was saved. Was not able to find it.

[davjoh123@yahoo.com]

Re: Saved Import Access 2007

On May 12, 9:20 am, "davjoh...@yaho o.com" <davjoh...@yaho o.comwrote:

On May 11, 11:42 pm, "Larry Linson" <boun...@localh ost.notwrote:
>
>
>

In some earlier versions ofAccess, if you save too early in a manualimport
process, theImport-Export Spect may not reflect all (or any) of the changes
you made. Try importing, creating the specification, and saving at the very
end of theimportproces s. As I am not in a position to test inAccess2007, it would be helpful if you would post your results back to this
message thread.

>

Larry Linson
Microsoft OfficeAccessMVP

>

<davjoh...@yaho o.comwrote in message

>

news:2ac954af-8f0f-4a72-a428-d1e30ca1ea66@p3 9g2000prm.googl egroups.com...

>

>I havesavedanimpo rtand it works great. I would like to be able to
start thesavedimportf rom a button on a switchboard. I tried using
TransferText and thesavedimportn ame but it does not recognize the
>savedname as animportspecifi cation.

>

Thanks for any help

>
I went looking for the MSysIMEXSpecs table to verify that the import
spec was saved. Was not able to find it.

Found System tables
Office button, Access Options, Current Database, Navigation Options,
Show System Objects

Import Name saved was different than what was showing in the Saved
Import tab in External Data.