I am connecting from VB6 to an Excel database using ADO. I also have on the form a datagrid. The datagrid works nice. But when I try to update the recordsource with a SQL select statement (such as [login to view URL] = "select [Account],[Service],[Company],[Address1],[City],[State],[ZIP],[MeterID],[Type] from [datafile$] where [Account] = " & [login to view URL]) --- this statement works ONLY IF [login to view URL] is a number. If you put any alpha characters in there - it bombs - error: "Too few parameters. Expected 1"
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.