Code doesn't find newly imported data in a table

[Bill R via AccessMonster.com]

My code deletes all existing records in a table in my db. Then it imports new
data from a CSV file. However, when subsequent sql code runs, it doesn't seem
to "see" the new data. Do I need to refresh the data? I am using the
following transfertext method:

DoCmd.TransferText acImportDelim, , "DMS_Report", strPath & strFile, True

Once the code finishes I can see the new records in the table, but the code
that immediately follow the transfer can't read the new records.

 

[Roger Carlson]

It depends on what the code following this looks like. Can you supply that?

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Bill R via AccessMonster.com]

Thanks for your response. I don't know what was happening, but it seems to be
working OK now. Mysterious!

It depends on what the code following this looks like. Can you supply that?

My code deletes all existing records in a table in my db. Then it imports new
data from a CSV file. However, when subsequent sql code runs, it doesn't seem

[quoted text clipped - 5 lines]

Once the code finishes I can see the new records in the table, but the code
that immediately follow the transfer can't read the new records.