Dear All,
I have a database uploaded to a Sharepoint site and I would like to run an append query to insert records to that database
Here is the SQL code:
When running the query I get an error message that "Not a valid file name"
Could you please advise?
(nb I am the admin of the Sharepoint site so I have full access to it)
Many thanks in advance
I have a database uploaded to a Sharepoint site and I would like to run an append query to insert records to that database
Here is the SQL code:
Code:
INSERT INTO tbl_body_main ( RegDatum, Branch, Nev, PersCode, Date1, Date2, Sorsz, KonyvKod, CC, SzlaCC, Típus, Költségcím, Ossz, UanyagL, FizMod, DevizaNem, Comment ) IN 'http://ts1.pro.intra/sites/HUFinance/Unrestricted_Documents/elszamolas.accdb'
SELECT tbl_body_main.RegDatum, tbl_body_main.Branch, tbl_body_main.Nev, tbl_body_main.PersCode, tbl_body_main.Date1, tbl_body_main.Date2, tbl_body_main.Sorsz, tbl_body_main.KonyvKod, tbl_body_main.CC, tbl_body_main.SzlaCC, tbl_body_main.Típus, tbl_body_main.Költségcím, tbl_body_main.Ossz, tbl_body_main.UanyagL, tbl_body_main.FizMod, tbl_body_main.DevizaNem, tbl_body_main.Comment
FROM tbl_body_main;When running the query I get an error message that "Not a valid file name"
Could you please advise?
(nb I am the admin of the Sharepoint site so I have full access to it)
Many thanks in advance
