Database grows extremly after DoCmd.TransferSpreadsheet acImport

[alexalex_ru]

After code runs:
DoCmd.TransferSpreadsheet acImport, , "Temptable1", FilePath, True, "Sheet1!A1:AX65000"
Access freezes and after 20 min exeption is throws because size of database grows from 15Mb to 2Gb.
I know the size limits of file. And seems that database grows because of error tables created. But why and how to stop it?

[lfpm062010]

The error table file contains information on why the spreadsheet can't be imported or can't convert value or ... etc.

Correct your error on the spreadsheet or change your table to accept the value. Then try again.

Questions: how many columns and rows do you have on the spreadsheet? You should not need to specific the range unless there is break in the spreadsheet.

[alexalex_ru]

Number of rows is varied. At moment around 7000, but range of columns is always from A to AP.
You mean it's better use? :
DoCmd.TransferSpreadsheet acImport, , "Temptable1", FilePath, True, ""
But why size grows to 2Gb? It looks unnormaly...

[orange]

To recover lost/inaccessible space, do a Compact and Repair.

[alexalex_ru]

Sometimes there are blank values in first rows

[alexalex_ru]

sure i do compact and repair

[lfpm062010]

Compact and Repair will help. Clean up the data and do compact and repair and try the TransferSpreadsheet again.

7000 rows should not cause it to grow to 2 GB. Unless every column contains lots text data.

TransferSpreadsheet will usually use the first sheet on the file. So, the "Sheet1!A1:AX65000" is optional.

[alexalex_ru]

Seems that database has hanging because there was 99 tables with import errors. Seems that 99 tables is a limit.

[lfpm062010]

There is no need to keep the spreadsheet import error tables. Once you have resolve your error, there is no need to keep the error tables.

I don't know the limit of the error tables. But, I am sure I can find it.