Importing text file into access with condition

[lokeshsu]

Hi all,

can we import a text file which has 25 lakhs of data in it and i need to import with a criteria like date which is greater than last week.

 

[Kreszch68]

Depending on if the txt file is well structured, but assuming it is, you can link the file to your database. Then use the linked file in an append query, with the right conditions, to transfer data to a native Access table. Or create a make table query if there is no native table yet.