Import Saved Imports from one DB to Another (1 Viewer)

N

net

Registered User.

Local time

Yesterday, 19:46

Joined

Mar 12, 2006

Messages

50

• Sep 18, 2019

• #1

Hello,

Is it possible to import all of my saved imports from one db to another? I have so many and would like to avoid re-creating them if possible. I am using MS Access 2016.

Thank you.

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:46

Joined

Aug 30, 2003

Messages

36,124

• Sep 18, 2019

• #2

If you're using the import functionality from the ribbon, there's an "Options" button that lets you include import/export specs.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 10:46

Joined

May 7, 2009

Messages

19,229

• Sep 18, 2019

• #3

open the db where you want to Import.
goto External data->New Data Source->From Database->Access
choose the db where the import is coming.
on "Import Objects" window click on "Options" and check "Import/Export Specs".

 

N

net

Registered User.

Local time

Yesterday, 19:46

Joined

Mar 12, 2006

Messages

50

• Sep 18, 2019

• #4

Thank you SO MUCH pbaldy and arnelgp for the prompt response.

I was able to import everything over to a new db.

Much appreciated. :-D

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:46

Joined

Aug 30, 2003

Messages

36,124

• Sep 18, 2019

• #5

Happy to help!