Hi,
I have a list of account numbers, that changes daily.
It is exported to an excel file, where I want to run a lookup on an Access Database and retrieve information about that account
I have tried coding for this, but I am stuck.

I manage to pull back the account details for a small number of accounts, but when i try using the full list (total number of characters in my SQL command exceed limit), my code is falling over.

Could anyone offer any advice, or solutions to my problem

I am a complete SQL novice, and I have been using the wizards to retrieve my data.

If you need any more info, please let me know.

Thanks
Mitch