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

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

On Fri, 26 Aug 2005 12:57:02 -0700, "Joaq"
<Joaq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Thanks John. I already installed Service Pack 1 for Office 2003. For some
>reason, same is able only for Windows, Word and Excel... but for Access!!

1) I'm sorry, I can't understand "same is able only for Windows, Word
and Excel... but for Access!!". Please explain precisely what you mean.

2) Did you try repairing your Office 2003 installation as I described in
my last message? If not, please do so.

>I tried also import the text files by using DoCmd.TransferText, It worked!
>but only for the first 5 columns and the text file contains 10 columns.

Try this:

1) Open the Northwind sample database, display the Database Window, and
export the Employees table to a text file, accepting all the default
settings in the wizard except for specifying "field names in first row".

2) Close Northwind, create a new empty database, and use File|Get
External data to import the text file.

Does this work properly? If so, the problem could be with the text file
you are trying to import, or with the database your are importing it
into? If not, exactly what happened?


>I'll really appreciate your help with this.
>
>Best regards.
>
>P.D. The problem happens after I setect the file name and click on "Import"
>button, and before the wizard displays the "Import Text Wizard" window, where
>a sample of the data to be imported appears.
>
>"John Nurick" wrote:
>
>> I'm a little surprised you got the hotfix because the description you
>> give of your problem does not match the text import problem that the
>> hotfix addressed, which was the problem with entering field information
>> into the wizard.
>>
>> Have you installed Service Pack 1 for Office 2003?
>>
>> Have you repaired your Office 2003 installation? (go to Control
>> Panel|Add or Remove Programs, select Office 2003 and then Change).
>>
>> If neither of those fixes the problem, we need to find out at exactly
>> what point Access crashes when you try to import a text file. Is it
>> before the wizard opens? while you're using the wizard? or after you've
>> finished with the wizard (i.e. during the actual import)?
>>
>> Can you import or link a CSV file successfully using DoCmd.TransferText?
>>
>>
>>
>>
>>
>> On Wed, 24 Aug 2005 16:52:01 -0700, "Joaq"
>> <Joaq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >Hi John!
>> >
>> >Thanks for your answer. I've tried to import different .txt and .csv files
>> >in different databases, without success. Somebody told me that I needed to
>> >get the hotfix En_US 837003, so I contacted Microsoft Support Center and they
>> >gave us the link and password to install the patches. After we installed the
>> >hotfix, Access 2003 still give the same problem, I'm not sure, but... do you
>> >think it is some problem with the wizard? Because same doesn't work
>> >importing any file, but tables from another database.
>> >
>> >Could you please write to my hotmail? jomscg@xxxxxxxxxxx
>> >
>> >Thanks and best regards.
>> >
>> >"John Nurick" wrote:
>> >
>> >> 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.
>> >>
>>
>> --
>> 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.
.

Relevant Pages

  • Sharepoint - "Cannot connect to the configuration database"
    ... Update for SQL Server 2000 Desktop Engine on Windows ... "Cannot connect to the configuration database. ... Event Category: Installation ...
    (microsoft.public.windows.server.sbs)
  • XP Embedded database fails to install on XP SP2
    ... I just downloaded the evaluation version of Windows XP Embedded SP2 from MS ... Clean installation of Windows XP SP2 into a VirtualPC. ... Installed the MSDE database engine sucessfully, ...
    (microsoft.public.windowsxp.embedded)
  • Re: win2k to winXP...
    ... | It says in the article that you have to create a Wizard Disk on your new ... | *Migrating to a Clean Installation Of Windows XP* ... |> Thanks, John John. ...
    (microsoft.public.win2000.general)
  • Re: "All fax printers are inaccessible" after Remove-then-Add Fax
    ... When I add Fax Services using Add/Remove Windows ... Components, the WIndows Components Wizard appears, with the checkbox for Fax ... You ask about my Windows XP version and source of installation files. ...
    (microsoft.public.windowsxp.print_fax)
  • Cannot add, edit or delete an access database created with FP wizard
    ... Just starting to use FP wizard. ... into an access database created with the FP database wizard. ... Windows XP Pro machine. ... the fpdb directory in windows has the readonly parameter ...
    (microsoft.public.frontpage.client)