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
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
Select 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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.