I have an Excel sheet called tool.xls that several (4 or 5) people at m
office are running copies of.

During the running of this spreadsheet it stores the person who i
running the sheets name and a long list (up to 1000) of accoun
numbers.

I want to have a button that they press which will export this list t
an access database and I want a drop down list (of the people tool.xl
names) that will enable them to import the list back into Excel for th
sheet to be able to use (thus allowing them to effectively save thei
work overnight.)

I'm having problems!!!

I think I understand how to connect the two programs (I've read up o
threads like "Connection using ADO" number 136375) but I can't write
line of code that selects 1000+fields to export or import.

Please help

--
Peter
-----------------------------------------------------------------------
Peter T's Profile: http://www.officehelp.in/member.php?userid=6
View this thread: http://www.officehelp.in/showthread.php?t=65731
Visit - http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.ph