Hi,
could you tell me the code how I could fetch some data from SQL server table into Access table.
Connections are ok, that is not a problem. The issue is that I don't know how to actually put the data into the Access table.
SQL = "INSERT INTO Table (Name) SELECT ac_name From Account where ac_name = '11111'"
the Table is the Access table and the account table is in the SQL Server. How I should do this to make it work...?