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

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.
.