Saved Import Access 2007

[davjoh123]

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]

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
<da*******@yahoo.comwrote in message
news:2a**********************************@p39g2000 prm.googlegroups.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]

On May 11, 11:42 pm, "Larry Linson" <[e-mail]:

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 theimportprocess. 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

<[e-mail] in message

news:2a**********************************@p39g2000 prm.googlegroups.com...

I havesavedanimportand it works great. I would like to be able to
start thesavedimportfrom a button on a switchboard. I tried using
TransferText and thesavedimportname but it does not recognize the
savedname as animportspecification.

Thanks for any help

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

[davjoh123]

On May 11, 11:42 pm, "Larry Linson" <[e-mail]:

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 theimportprocess. 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

<[e-mail] in message

news:2a**********************************@p39g2000 prm.googlegroups.com...

I havesavedanimportand it works great. I would like to be able to
start thesavedimportfrom a button on a switchboard. I tried using
TransferText and thesavedimportname but it does not recognize the
savedname as animportspecification.

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]

On May 12, 9:20 am, "[e-mail]" <[e-mail]:

On May 11, 11:42 pm, "Larry Linson" <[e-mail]:

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 theimportprocess. 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

<[e-mail] in message

news:2a**********************************@p39g2000 prm.googlegroups.com...

>I havesavedanimportand it works great. I would like to be able to
start thesavedimportfrom a button on a switchboard. I tried using
TransferText and thesavedimportname but it does not recognize the
>savedname as animportspecification.

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.