Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Get External Data (import)

Discussion in 'Information Technology' started by John Nurick, Oct 26, 2005.

  1. John Nurick

    John Nurick
    Expand Collapse
    Guest

    The following steps usually fix this and similar problems. If they
    don't, or if the files referred to below don't exist, it may be
    necessary to install stuff.

    f the import/export wizards don't work at all, or if you get "No object
    in this control" re-register ACCWIZ.DLL.

    If it's one or more file formats that aren't listed, re-register the
    following files
    msexcl40.dll (Excel)
    msxbse40.dll (dBase)
    mspdox40.dll (Paradox)
    mstext40.dll (Text, CSV, tab-delimited))
    In Access 97, the filenames contain 35 instead of 40.

    To re-register a DLL file,

    1) Locate it (usually all these are in the Windows\System32 or
    WINNT\System32 folder.

    2) Locate the file regsvr32.exe.

    3) Drag the DLL file's icon onto the regsvr32.exe icon.

    On Tue, 25 Oct 2005 15:20:48 GMT, "bill" <WBeatty@Prodigy.Net> wrote:

    >
    >When selecting Get External Data in Access 2003, I don't see all the file
    >extension types as an option to import. For example, I do not have the
    >option to select an Excel file to import.
    >
    >Any help is appreciated.
    >
    >


    --
    John Nurick [Microsoft Access MVP]

    Please respond in the newgroup and not by email.
     
  2. Loading...


  3. bill

    bill
    Expand Collapse
    Guest

    This fixed the problem....thanks.

    "John Nurick" <j.mapSoN.nurick@dial.pipex.com> wrote in message
    news:l1etl1d87p9a7qkv8blt7mc9v32e7ukf2q@4ax.com...
    > The following steps usually fix this and similar problems. If they
    > don't, or if the files referred to below don't exist, it may be
    > necessary to install stuff.
    >
    > f the import/export wizards don't work at all, or if you get "No object
    > in this control" re-register ACCWIZ.DLL.
    >
    > If it's one or more file formats that aren't listed, re-register the
    > following files
    > msexcl40.dll (Excel)
    > msxbse40.dll (dBase)
    > mspdox40.dll (Paradox)
    > mstext40.dll (Text, CSV, tab-delimited))
    > In Access 97, the filenames contain 35 instead of 40.
    >
    > To re-register a DLL file,
    >
    > 1) Locate it (usually all these are in the Windows\System32 or
    > WINNT\System32 folder.
    >
    > 2) Locate the file regsvr32.exe.
    >
    > 3) Drag the DLL file's icon onto the regsvr32.exe icon.
    >
    > On Tue, 25 Oct 2005 15:20:48 GMT, "bill" <WBeatty@Prodigy.Net> wrote:
    >
    >>
    >>When selecting Get External Data in Access 2003, I don't see all the file
    >>extension types as an option to import. For example, I do not have the
    >>option to select an Excel file to import.
    >>
    >>Any help is appreciated.
    >>
    >>

    >
    > --
    > John Nurick [Microsoft Access MVP]
    >
    > Please respond in the newgroup and not by email.
    >
     
  4. Marty

    Marty
    Expand Collapse
    Guest

    Will re-registering the ACCWIZ.DLL file so I can do imports in new databases
    I create in Access 2003 in anyway impact/affect the Access 2000 databases
    that I am not yet ready to convert to 2003?

    Thanks,
    Marty

    "John Nurick" wrote:

    > The following steps usually fix this and similar problems. If they
    > don't, or if the files referred to below don't exist, it may be
    > necessary to install stuff.
    >
    > f the import/export wizards don't work at all, or if you get "No object
    > in this control" re-register ACCWIZ.DLL.
    >
    > If it's one or more file formats that aren't listed, re-register the
    > following files
    > msexcl40.dll (Excel)
    > msxbse40.dll (dBase)
    > mspdox40.dll (Paradox)
    > mstext40.dll (Text, CSV, tab-delimited))
    > In Access 97, the filenames contain 35 instead of 40.
    >
    > To re-register a DLL file,
    >
    > 1) Locate it (usually all these are in the Windows\System32 or
    > WINNT\System32 folder.
    >
    > 2) Locate the file regsvr32.exe.
    >
    > 3) Drag the DLL file's icon onto the regsvr32.exe icon.
    >
    > On Tue, 25 Oct 2005 15:20:48 GMT, "bill" <WBeatty@Prodigy.Net> wrote:
    >
    > >
    > >When selecting Get External Data in Access 2003, I don't see all the file
    > >extension types as an option to import. For example, I do not have the
    > >option to select an Excel file to import.
    > >
    > >Any help is appreciated.
    > >
    > >

    >
    > --
    > John Nurick [Microsoft Access MVP]
    >
    > Please respond in the newgroup and not by email.
    >
    >
     
  5. John Nurick

    John Nurick
    Expand Collapse
    Guest

    Hi Marty,

    If you're using Access 2003, I don't see how it can. If you have more
    than one version of Access on your computer, see
    http://support.microsoft.com/kb/828956/


    On Fri, 28 Oct 2005 15:26:02 -0700, "Marty"
    <Marty@discussions.microsoft.com> wrote:

    >Will re-registering the ACCWIZ.DLL file so I can do imports in new databases
    >I create in Access 2003 in anyway impact/affect the Access 2000 databases
    >that I am not yet ready to convert to 2003?
    >
    >Thanks,
    >Marty
    >
    >"John Nurick" wrote:
    >
    >> The following steps usually fix this and similar problems. If they
    >> don't, or if the files referred to below don't exist, it may be
    >> necessary to install stuff.
    >>
    >> f the import/export wizards don't work at all, or if you get "No object
    >> in this control" re-register ACCWIZ.DLL.
    >>
    >> If it's one or more file formats that aren't listed, re-register the
    >> following files
    >> msexcl40.dll (Excel)
    >> msxbse40.dll (dBase)
    >> mspdox40.dll (Paradox)
    >> mstext40.dll (Text, CSV, tab-delimited))
    >> In Access 97, the filenames contain 35 instead of 40.
    >>
    >> To re-register a DLL file,
    >>
    >> 1) Locate it (usually all these are in the Windows\System32 or
    >> WINNT\System32 folder.
    >>
    >> 2) Locate the file regsvr32.exe.
    >>
    >> 3) Drag the DLL file's icon onto the regsvr32.exe icon.
    >>
    >> On Tue, 25 Oct 2005 15:20:48 GMT, "bill" <WBeatty@Prodigy.Net> wrote:
    >>
    >> >
    >> >When selecting Get External Data in Access 2003, I don't see all the file
    >> >extension types as an option to import. For example, I do not have the
    >> >option to select an Excel file to import.
    >> >
    >> >Any help is appreciated.
    >> >
    >> >

    >>
    >> --
    >> John Nurick [Microsoft Access MVP]
    >>
    >> Please respond in the newgroup and not by email.
    >>
    >>


    --
    John Nurick [Microsoft Access MVP]

    Please respond in the newgroup and not by email.
     
  6. Marty

    Marty
    Expand Collapse
    Guest

    Thanks so much for the information John! It worked and I am one very HAPPY
    camper!

    "John Nurick" wrote:

    > Hi Marty,
    >
    > If you're using Access 2003, I don't see how it can. If you have more
    > than one version of Access on your computer, see
    > http://support.microsoft.com/kb/828956/
    >
    >
    > On Fri, 28 Oct 2005 15:26:02 -0700, "Marty"
    > <Marty@discussions.microsoft.com> wrote:
    >
    > >Will re-registering the ACCWIZ.DLL file so I can do imports in new databases
    > >I create in Access 2003 in anyway impact/affect the Access 2000 databases
    > >that I am not yet ready to convert to 2003?
    > >
    > >Thanks,
    > >Marty
    > >
    > >"John Nurick" wrote:
    > >
    > >> The following steps usually fix this and similar problems. If they
    > >> don't, or if the files referred to below don't exist, it may be
    > >> necessary to install stuff.
    > >>
    > >> f the import/export wizards don't work at all, or if you get "No object
    > >> in this control" re-register ACCWIZ.DLL.
    > >>
    > >> If it's one or more file formats that aren't listed, re-register the
    > >> following files
    > >> msexcl40.dll (Excel)
    > >> msxbse40.dll (dBase)
    > >> mspdox40.dll (Paradox)
    > >> mstext40.dll (Text, CSV, tab-delimited))
    > >> In Access 97, the filenames contain 35 instead of 40.
    > >>
    > >> To re-register a DLL file,
    > >>
    > >> 1) Locate it (usually all these are in the Windows\System32 or
    > >> WINNT\System32 folder.
    > >>
    > >> 2) Locate the file regsvr32.exe.
    > >>
    > >> 3) Drag the DLL file's icon onto the regsvr32.exe icon.
    > >>
    > >> On Tue, 25 Oct 2005 15:20:48 GMT, "bill" <WBeatty@Prodigy.Net> wrote:
    > >>
    > >> >
    > >> >When selecting Get External Data in Access 2003, I don't see all the file
    > >> >extension types as an option to import. For example, I do not have the
    > >> >option to select an Excel file to import.
    > >> >
    > >> >Any help is appreciated.
    > >> >
    > >> >
    > >>
    > >> --
    > >> John Nurick [Microsoft Access MVP]
    > >>
    > >> Please respond in the newgroup and not by email.
    > >>
    > >>

    >
    > --
    > John Nurick [Microsoft Access MVP]
    >
    > Please respond in the newgroup and not by email.
    >
    >
     

Share This Page