Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Execute SQL queries to Microsoft Access

ADMIN

Access files consist of tables. We can execute SQL queries to those tables, using the "Database" Actions.


You can check the following sample queries. The relevant Access file is attached below.

  • SELECT * FROM [Students];
    Students represents a Table within the selected file. It needs to be included in square brackets.

  • SELECT [Full Name] FROM [Students] WHERE [ID] =1;
    Our Columns, Full Name and ID, need to be included in square brackets.

  • INSERT INTO [Books] ([Book Name], [ID]) VALUES ('The Odyssey', 4);

  • UPDATE [Students] SET [Full Name] = 'Leonardo N' WHERE [ID] = 3;


Check this article for more detailed information.

waj
(704 KB)
Login or Signup to post a comment