Re: Importing table from text file to Access...

The ordinary ways of importing data from text files have scarcely
changed since Access 97. Some things that have changed:

- files with non-standard extensions (e.g. .dat instead of .txt cannot
be imported with the default setup.

- text files must have the Windows-standard CR + LF between records
(Access 97 was more forgiving).

But neither of these should cause Access to crash. Do you get the
problem with any text file and any database, or just with one particular
file, or one particular database?



On Mon, 22 Aug 2005 17:15:02 -0700, "Joaq"
<Joaq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>When importing a text file in order to create a new Access table, the program
>displays the following error: "Microsoft Office Access has encountered a
>problem and needs to close. We are sorry for the inconvenience."
>
>Could you please advise the best way to import a text file to the Access
>2003 tables? I didn't have any problem with the 97 version.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: Corrupt Mailbox Store
    ... transactions involved with the exporting and importing. ... The other question you had was why the database grew. ... > it cleared all of those excessive log files. ...
    (microsoft.public.exchange2000.information.store)
  • Re: Importing Text
    ... I have been having trouble importing a large text file in Access 2003. ... proportions into my Access 2003 database without any trouble. ... quarterly project I would like to fix this import problem for the future. ...
    (microsoft.public.access.externaldata)
  • OMPM import issue
    ... importing into an OMPM database on SQL Server 2005. ... Move all of the CAB files out of the OMPMImported folder. ... the CAB and importing the XML files in smaller batches. ...
    (microsoft.public.office.setup)
  • RE: Code not importing with forms
    ... I went through the process of importing all objects into a new blank ... database again today and it worked fine. ... Click on the tool bar button that opens the form module. ... blank mdb and then importing all objects from the corrupt mdb. ...
    (microsoft.public.access.externaldata)
  • Re: Baffled By Security Wizard
    ... I did in fact add the Group to my secure workgroup. ... I'm not clear on why importing the ... objects into a new database was critical. ...
    (microsoft.public.access.security)
Loading