Parameterized queries

Hi, I am using ADO against an Sql Server 2000 backend. My problem is
I'm trying to use a dynamic sql query as part of an import csv process.
The final stage after matching field names, etc is to build a
parameterized query.

Unfortunatly when it comes to executing the command all I get is the
error "Must declare the variable @name". From what I could find it
seems that ADO will not support parameterized queries.

Could anyone please advise if the know of a way to get this to work
with ADO or an alternative.

Thanks, Chris.

.

Relevant Pages

  • Re: Parameterized queries
    ... MVP - Technologies Virtual-PC ... I'm trying to use a dynamic sql query as part of an import csv process. ... seems that ADO will not support parameterized queries. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help with SQL statement
    ... I've never used ADO with an Access backend, only with SQL Server, and the ... I will use the append query version. ...
    (microsoft.public.access.reports)
  • Re: User Roster for a secured backend
    ... The link from the frontend to the backend is using DAO the link you are ... > Microsoft code on the Jet User Roster that uses ado to develop a list. ... > Workgroup file passwords aren't available for the CurrentUser, ...
    (comp.databases.ms-access)
  • Oracle and Access
    ... I am looking for the MOST efficient way to pull data from an Oracle ... Not sure if I should just link to the backend and run a single query to ... or if I should use ADO? ...
    (comp.databases.ms-access)
  • User Roster for a secured backend
    ... I'm trying to determine who is linked to the backend. ... Microsoft code on the Jet User Roster that uses ado to develop a list. ... Workgroup file passwords aren't available for the CurrentUser, ...
    (comp.databases.ms-access)
Loading