Counting records imported with the Transfertext method

[James D.]

Background: Weekly we import information into a table from a text file via
the Transfertext method.

Problem: I wish to obtain through code the number of records sucessfully
imported from the text file, but cant seem to find that option in the help
for the transfertext method.

I know I can just count the records in the table I am importing into before
then subtract the after difference, but was wondering is anything more direct
exists?

Any help would be greatly appreciated.

thx.

 

[Jeff C]

Import your data into a temporary table and apply some queries finishing with
an append query placing your new data in the existing table and deleting the
data in the temporary table. You could probably come up with a msgbox
displaying the number of records placed in the temporary table

 

[James D.]

Thank you! What I pretty much have done is created a function that counts
the records in the table via recordsets and is called prior to the file
import, and after the successfull file import and it seems to work. I was
kinda hoping there would be some property of the transfertext method that I
could access that does the same thing, but I have not been able to locate it.

Thanks again.

James.

 

[Jeff C]

combine your function with the transfertext action and a temporary table
finishing the sequence off with an append query from the temporary table to
you main data table, good luck