Docmd.transfertext gives error

[Guest]

I have an Access 2000 ADP frontend and SQL Server 2000. All workstations run
windows 2000.

I need to import a large text file from the client into the SQL Server . The
text file consists of about 150 000 records, each record has only one field
with about 120 characters. In the Access ADP client i do the following line
of code:

DoCmd.TransferText acImportDelim, "", "SQLServerTableName",
PathAndNameOfImportFile, False


The import starts as expected but fails after a few minutes, I guess when
the job is about 80% done. I get the following error message:

Your computer is out of disk space You won't be able to undo this paste
append. Do you want to continue anyway?

I respond on yes-button to this message. Then, after another few seconds
the system gives me an error message on the docmd.transfertext codeline and
stops. The table on SQL Server is empty.

How can I overcome my problem?

I know I can probably import the file directly to SQL Server by use of SQL
Server tools (DTS), but that is not what I want to do.

Regards

Tore G.

 

[Sylvain Lafontaine]

80% completed: how did you find that? Take a smaller file, something like
15000 records, and you will see that the transfert process is slower than
you think.

Your best option might be to open the file and transferts all the items
yourself with VBA code.