how to open a large text file to see data

If you aren't adding new records then option 1 will be the favourable approach.Ĭlick to expand.Unfortunately you're still thinking of your Access database as an Excel spreadsheet. now this is a Bulk update/insert which the Jet Engine handles nicely.

The join will be between the Instr/Mid field and the respective Speciality field Create an appropriate INNER JOIN between the linked table and the Speciality table using Instr() and Mid().For example, you have to insert one record at a time. Note the major bottlenecks highlighted in blue. The check must use an appropriate search method, i.e.:.For each record in the file you check if a corresponding record exists in the Speciality table.

You then also have a recordset of your Speciality table.You load the file into memory using one of the above methods.Loop and FIND method using a recordset/file system object/ Open file/ADO text provider etc methods: You're using Split() but split isn't the only way of identifying the right part of your record string.

How to open a large text file to see data