How do I extract data from database file to .xls file?
Asked By
30 points
N/A
Posted on - 11/20/2012
I have some important data in my database and need to extract it immediately to .xls file.
How can I do that?
How do I extract data from database file to .xls file?
Hi!
Do the Select Into Outfile syntax. It will let you make a CSV file where it will become readable by Excel.
But you have to remember to name it as .cs since .xls is not supported by some open source applications.
And you can import CSV files compatible with the database in Excel.
Â
Best Answer
Best Answer
How do I extract data from database file to .xls file?
Dear Casey cock,
You can import data from database to Excel file by following these steps:
1. Open a new excel file.
2. Click on data tab from the above menu and select get external data.
3. From the external data menu select from access.
4. A new window will open then browse through it to open your database.
5. Then after selecting your database a new window appear for adjusting the format of your data in the excel file.
6. You have your data copied into excel sheet.
Latest Articles
Krikya Bangladesh Review: A Comprehensive Guide To Its Betting Services
Discover the ins and outs of Krikya Bangladesh, a prominent bookmaker in the online betting scene. This detailed review covers everything from the diversity of sports betting options and casino games to user experience, security measures, and customer support efficiency. Whether you're a seasoned bettor or new to the online gambling world,
find out how Krikya stands out in the competitive market of Bangladesh.
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
