none
Runtime Error 3001: Invalid Argument RRS feed

  • Question

  • Anyone knows how to fix the query syntax?

    Thanks.

    SybaseConnString = "Driver={Adaptive Server Enterprise};app=myAppName;server=myServerAddress;port=myPortnumber;db=myDataBase;uid=myUsername;pwd=myPassword;"
    
    SyQuery = "SELECT * INTO AccessTableName FROM [" & SybaseConnString & "].[SybaseTableName]"
    
    DoCmd.RunSQL SyQuery

    Thursday, August 30, 2018 6:16 PM

All replies

  • It's not obvious to me what's wrong.  If you construct that exact same SQL statement, put it into a stored query (via SQL view), and execute it, do you get an error or does it work?

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Thursday, August 30, 2018 10:06 PM