0
No. Excel is a spreadsheet package, not a file. You can use some basic database functions within Excel and you can also use Excel to store database information. However, in this respect, Excel is better for databases that are essentially flat files - Excel is not best suited for complex database structures.
What else can I help you with?
How do you convert a ms Works database file to a Microsoft Excel file?
Export the MS Works database file in a comma-delimited format, save the file, then import the file into MS Excel.
Is Excel capable of making database?
No, Excel cannot make a database file. However, databases can be imported onto it. The primary software for making a database is Microsoft Access.
What are the details about a file in Excel called?
Database Properties
How do you export foxpro file to excel?
use the database execute the following command export to <new file> type xls the above command will convert your foxpro database into XL file. each filed in the database will be changed as column in xls file.
How do you export data from a Dos ver 5 database to Excel?
A good way is to export from a database is to save as CSV format (or some sort of comma-delimited text format), then open Excel and import the file into Excel.
Can an existing database be recalibrated when you start Excel?
All formulas recalculate when Excel opens, so if a database in Excel has formulas in it, it will be recalibrated. It could also be linked to another file or external source which may make it change when it is opened.
What technologies should be used for uploading an excel file and processing it to the database?
Using struts we can do it samir
How do you convert an Excel database to a Mysql database?
1. For every sheet you have in Excel, create a matching table in MySQL database 2. Export excel data to a CSV file 3. Load the CSV files into MySQL database using one of the following: 3.1 mysqlimport - Loads tables from text files in various formats 3.2 LOAD DATA INFILE command 3.3 Create the tables with CSV storage engine, replace the CSV file in the database directory
What type of file you create with Microsoft Office Excel 2007 is called a database?
MS Excel is a spreadsheet program that creates files called workbooks.
How do you form a primary key column in Microsoft Excel?
Just type your data into the column. Excel is not really a database program, but you can create a flat database file and some elementary relations between worksheets. A better tool for a database would be MS Access.
Which default Database roles are created when you create a Database?
To create a database you need to name a file and add that to Microsoft excel :) hope that helps :)
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
