Using an existing table in a VBA routine

[Jagerdawg]

I currently have a VBA routine I use to parse a text file which holds 5 million account numbers. I also have a table that lists individual account numbers that may be found in the text file. I would like to use this existing table as criteria selection when parsing the text file. I currently am using a case statement as a work around.

Thank you in advance... ray:

 

[Dugantrain]

Not exactly sure if this is what you need, but if you're just looking to return the records from the text file that have a matching account number in your table, you can use a query with a subquery as it's criteria:

SELECT * FROM Your_Text_File WHERE [Account_Number] IN (SELECT [Account_Number] FROM Your_Account_Table)

 

[Jagerdawg]

Thanks. However, I would like to test the account numbers verse the table while the parsing routine is running.

For example: The table contains account number "ABC".

As the parsing routine runs it compares each new line contains account number "ABC" in a specific location on the line.

"123" Skip
"ABC" Process
"@@@" Skip

 

[bat17]

Are you trying to restrict data available to your code depending on values in the look-up table? You should be able to do that using SQL with criteria.

Peter