[RESOLVED] Excel 2003 - DB Lookup - Querytables

[Mitch_s_s]

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

[Mitch_s_s]

sorry to bump the thread

i can record a macro which captures the SQL statement and returns the results to a query table

is there no way to create a function, that connects to the db and returns the result to a cell

as my list can become quite large, i cannot pass the list as one string in the query

thanks again

[Mitch_s_s]

nevermind eh

sorted it now

i joined the two tables in access, and created a query looking up the values i was interested in

i then created a querytable in excel to pull back the data

vlooked up that mother sucker, and jobs a good'n

thought i'd post back, in case anyone wanted to know lol