1.

How We Can Import Data From Database?

Answer»

we can import DATA from a database by SELECTING a QUERY from Microsoft Query or by manually specifying an SQL statement
Right-click on the Data Table SHEET to which you want to import the data and select Sheet > Import > from Database. The Database Query Wizard opens. Select your database selection preferences like create query using Microsoft query or specify SQL statement manually and click next. After words by specifying connecting STRING and SQL statements. We can get data from database to data table.

we can import data from a database by selecting a query from Microsoft Query or by manually specifying an SQL statement
Right-click on the Data Table sheet to which you want to import the data and select Sheet > Import > from Database. The Database Query Wizard opens. Select your database selection preferences like create query using Microsoft query or specify SQL statement manually and click next. After words by specifying connecting string and SQL statements. We can get data from database to data table.



Discussion

No Comment Found