Saved Imports

pdvsa
pdvsa used Ask the Experts™
on
experts,

I have been running a saved import to import tables.  I have been running the saved import for quite a few weeks.  I have discovered that if I add tables to the data file (I am running be an fe) and save the data then import into the fe, those tables that I created do not import.  I copy the data file from the network and then save it to my C: and overwrite the data that was there before.  I

It seems as though the saved import is only importing based on a previously recorded "map" and any new tables do not get imported.  I cant believe this is true but it seems as though it is.  

Am I doing something wrong?  
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
pdvsaProject finance

Author

Commented:
the line here does not mention anything to be careful of when creating a saved import:
 
http://office.microsoft.com/en-us/access-help/run-a-saved-import-or-export-operation-HA001226020.aspx#2
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I can't be certain, but on the flip side of this issue, remember that there was never any claims that you "Could" swap files.

I have even had similar issues with Import Specs.


Keep in mind that depending on your requirements, importing Tables should be a rare event (in most cases)
(Importing the odd text file is another story)
Sometimes linking is a more efficient option for tables.

Other factors that may effect this are:
Stray data outside of the range
Access detecting different datatypes (based on the first few rows of data)
...etc

Finally:
"I have discovered that if I add tables to the data file (I am running be an fe) and save the data then import into the fe, those tables that I created do not import."
...Can you state clearly what this means.
What exactly are you referring to as the "Data File".
Also state what type of tables you are importing.

JeffCoachman
pdvsaProject finance

Author

Commented:
Jeff:
<What exactly are you referring to as the "Data File".
I have the db split into fe and be.  I go home after work and since the network connection thru the company I import the data into the fe to avoid linked tables to the be where the  data resides.  
<Also state what type of tables you are importing.
Not sure what you mean.  Many diff types such as tblEmployees, tblEndUser, many....

thx

PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

pdvsaProject finance

Author

Commented:
I am thinking now I should link and not delete the link tables in the db then reimport the data.  When I delete the tables then I also delete the relationships and while  I dont really need the relatioships I would like to have them.
MIS Liason
Most Valuable Expert 2012
Commented:
This is the issue with trying to "swap" BE tables.

Unless you have iron-clad code and Errorhandling, things can get deleted, overwritten, Jumbled, scrambled, corrupted, ...etc

What I typically do is to simply copy the Network tables into my "traveling" DB as static tables.
But if linking is a better/safer option for you, then go with it.

Jeff
pdvsaProject finance

Author

Commented:
Ok... At least i know that its not just me that has these issues.  

What did yoi mean by "copy" the tables into the traveling db?  I thought the only way to transfer tables in the db is by importing.  Thx
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
You can right-click a linked table and select Copy
Then when you right-click to Paste, select:  Structure And Data ( Local Table)

Or you can run a Make table on the linked table as well
pdvsaProject finance

Author

Commented:
Oh wow did not know that.  Thank you.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Just remember to keep the names straight, though...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial