Re: Missing Import Capability

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Hannah (BobAH_at_AOL.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 14:12:03 -0700

The ability ti import any records except through ODBC was
missing. I attempted to use the DNS part which also does
not work. The program DATA sources are missing that allow
you to do this did not install, also, everything is in
place for excel and does work.
>-----Original Message-----
>
>Hi Bob,
>
>You say "the ability to import fixed length records in
txt format is
>missing". I infer from this that you have no problem
importing delimited
>text files: please confirm that this is the case.
>
>Exactly what happens when you try to import a fixed-width
file? Have you
>scrutinised the files you have tried to import: is there
anything
>unusual in them?
>
>Do they have non-standard extensions? If so, see
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;304206 and
>http://support.microsoft.com/default.aspx?scid=kb;EN-
GB;306144
>
>If there's a schema.ini file in the directory you're
importing from,
>does it contain a section specifying the layout of the
file?
>
>Recent versions of Access are rather fussy about textfile
formats. You
>must have a CR+LF at the end of each record: Unix- or Mac-
style files,
>or fixed width files with no record separators, must be
converted before
>they will import. Also, you can't have CRs or LFs in the
data.
>
>
>
>
>
>
>On Fri, 23 Apr 2004 06:56:57 -0700, "Bob Hannah"
<BobAH@aol.com> wrote:
>
>>After doing a full install of Office XP, the ability to
>>import fixed length records in txt format is missing.
All
>>other formats is missing too except ODBC. Uninstalling
>>and reinstalling does not correct the problem. After
>>going through the registry I discovered that there were
>>some major errors there that did not correct with the
>>install. Also turning off the recovery ability and
>>replacing the MStext40.dll did not correct this
problem.
>>All patches and hotfixes were applied with out
correcting
>>this problem. Following the corrections for repairing
>>this problem from the knowledge base also did not
correct
>>this problem. Any help would be appreciated.
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>

Relevant Pages

  • Re: Missing Import Capability
    ... You say "the ability to import fixed length records in txt format is ... >import fixed length records in txt format is missing. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: Cancel car insurance, pay 80% premium?
    ... is merely pointing out stupid grammer ... If it was a singular missing comma, ... However, you appear to make spelling mistakes, can't find the shift key ... > in order to defeat my ability. ...
    (uk.rec.cars.misc)
  • he should sink sharply if Elizas activity isnt supporting
    ... Where will we register after Basksh troubles the historical commission's ability? ... For Lakhdar the entity's missing, unlike me it's dead, whereas including you it's dominating combined. ...
    (sci.crypt)
  • Re: Samsung A870: Quick way to get to vibrate mode?
    ... I just upgraded from my VX4400 to an A870, am also missing the ability to ... easily go to manner mode, doesn't seem to be an easy way. ... I've been through the user manual for the Samsung. ...
    (alt.cellular.verizon)
  • Missing Import Capability
    ... After doing a full install of Office XP, the ability to ... import fixed length records in txt format is missing. ...
    (microsoft.public.access.externaldata)