Question

i have an excel data and that i need to upload to Ms Access and connect access as DB using A360 could you please let me know the steps of adding data to access and connecting access as DB using A360 many thanks in advance

  • 15 June 2022
  • 1 reply
  • 24 views

i have an excel data and that i need to upload to Ms Access and connect access as DB using A360 could you please let me know the steps of adding data to access and connecting access as DB using A360 many thanks in advance

1 reply

Hi @Nakkireddyvari Tharaka Prabhu​ 

 

Step 1:

Download the Access Database Engine on Microsoft Portal

Link: https://www.microsoft.com/en-in/download/details.aspx?id=13255

Click on Download

imageSelect AccessDatabaseEngine.exe to download and get it installed

 

Step 2:

Database: Connect

Select connection mode as default and in the connection string using the below string to make your excel to connect with the database engine

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="ExcelPath";Extended Properties="Excel 12.0 Xml;HDR=YES"

 

Step 3:

Example Query how to use SELECT statement:

SELECT *FROM [SheetName$$] WHERE ColumnName = "Condition" and ColumnName = "Condition";

 

Hope I have answered your query, if yes Mark my answer as "Best" 🙂

 

Reply