Insert records to SQL table using MS Access (VBA)

[malibu65k]

Is it possible to Insert records to SQL table using MS Access (VBA)? Contractual issues won't allow me to fix anything on the SQL server but I have to insert records into some SQL tables but the records that I need to insert into the SQL tables are in MS Access tables. The MS Access application is linked to the tables and I can open and view the data and run queries against them. If it's possible, how do I insert records from the tables in MS Access into the SQL tables.

Thanks in advance!

 

[Golom]

Assuming that the SQL server tables are linked into Access, the usual way is

INSERT INTO mySQLServerTable (Fld1, Fld2, Fld3, ...)

SELECT FldA, FldB, FldC, ...
From myAccessTable
WHERE [blue]... Some logical Conditions ...[/blue]

This assumes of course that you are authorized to modify the SQL Server tables in question.

 

[malibu65k]

Thanks Golom! I'll try this tonight!

 

[malibu65k]

I'm getting a sqlstate 08004, sql error 4060, a logon/connection error. I'm guessing I don't have write access?

 

[dhookom]

Can you edit the records in the linked SQL tables? Does Access recognize the primary key field(s) of the SQL table(s)?

Duane
Hook'D on Access
MS Access MVP