Solved: Importing rows not more than 65000 records

[J_L]

Hi all,

I need to import notepad files to the table, Item. This table cannot have more than 65000 rows of records. How shld i do it?? :dunno

My import code onli have one statement. Below is the code.

DoCmd.TransferText acImportDelim, ItemSpec, Item, strPath, False

Thanks a lot..

[geekgirlau]

There are two methods of attack:

Read the text file line by line and update the table, and stop at record 65000;
Import the entire text file into a temporary table, append the first 65000 rows into your permanent table, then clear the temporary table

[Norie]

J_L

If you are using code then just set the variables as required.

[J_L]

Hi,

I've solved the problem.
I use the 2nd method recommend by geekgirlau..
thanks a lot..