Runtime Error 3001: Invalid Argument

[VAer]

Anyone knows how to fix the query syntax?

Thanks.

[/CODE]

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

[ranman256]

The connection is not part of the SQL.
select field from table

Your SQL makes no sense. Is it a select query,or append query?

[VAer]

The connection is not part of the SQL.
select field from table

Your SQL makes no sense. Is it a select query,or append query?

But I have to identify connection string somewhere, otherwise how it can know where to copy data from. Sybase is considered as external database, in this case.

Select Table, not select query.

Copy Sybase Table data into Access Table. I want VBA code only, not through menu bar ODBC button.

Thanks.

[June7]

SELECT INTO syntax will create a new table. If you want to add records to existing table use INSERT INTO SELECT syntax.

Is table really named AccessTableName?

Perhaps use TransferDatabase https://bytes.com/topic/access/answe...-automatically

[VAer]

SELECT INTO syntax will create a new table. If you want to add records to existing table use INSERT INTO SELECT syntax.

Is table really named AccessTableName?

Perhaps use TransferDatabase https://bytes.com/topic/access/answe...-automatically

No, it is substituted with AccessTableName when posting he question. In real code, I use the real table name.