smartchick wrote:

.CommandText = Array("SELECT * FROM
`C:\PaycheckData`.`3-2CurBMProfile`")
I want to add CompanyID (which the user choose in the Excel doc.

See:

http://www.dicks-clicks.com/excel/Ex...htm#Parameters
Jamie.

--