Can excel and access transfer info to one another

T

Tmahaff

I have a job management program we(my company) created in access but I also
have info in excel. I'm stuck trying to merge the two for my employees that
need info from both for use with PDA's.
 
D

Douglas J. Steele

Access can link to Excel (through File | Get External Data | Link).

Excel can run DAO (or ADO, I believe) code to retrieve data from Access.

Of the two, I'd recommend the first approach.
 
Top