....or you might first try ex****ting just the specs to another blank DB to
see
if they ex****t correctly.
"Phil Trumpy" wrote:
> I have an Access 2003 database that im****ts a number of different text
files
> once per week into various tables. These files have changes made to the
> layouts now and then, in which case, I usually start a manual im****t,
change
> the Im****t Spec accordingly and save it over the other one. Now, I
normally
> do this in a test version and then when I am ready to make the change in
the
> live DB, I copy and paste that spec from the test copy to the live copy.
It
> has always worked fine.
>
> Well, recently, there have been file layout changes to 3 of the files I
use.
> Now, for these files, I get an error stating that the im****t spec does
not
> exist and I cannot do the im****t. I have unhidden the system tables and
can
> see the im****t specs there, but I cannot use them.
>
> I have two questions:
>
> 1) Is there any way to fix this issue in the database without im****ting
all
> objects to a new blank database and recreating the im****t specs?
>
> 2) What could have caused this. This issue will happen all the time as
> people are constantly asking for changes made to these .csv files. I
don't
> want to go through this every time a layout changes.
>
> Thanks in advance for your time. I am using Access 2003 on a Windows XP
Pro
> Service pack 2 machine.
|
