aphun

• Sep 17th, 2012

 

Yes you can export data from a database into .csv, which in turn can be opened in excel or open office.

Note: Ive only tested this from a mysql database and then opening the csv in openoffice, but I dont see any reason why it would not work a Microsft SQL database. run the following query on a table on SQL..

Code
 


SELECT * INTO OUTFILE /tmp/customer.csv


  FIELDS TERMINATED BY ,


  OPTIONALLY ENCLOSED BY "


  LINES TERMINATED BY 


 


FROM customer


;

A

• Sep 19th, 2012

 

Yes you can

Waqas Ahmed

• Oct 6th, 2012

 

Here is the query to export data into csv file.

Code
SELECT *


INTO OUTFILE /tmp/products.csv


FIELDS TERMINATED BY ,


ENCLOSED BY "


ESCAPED BY 


LINES TERMINATED BY 


FROM products

avinash

• Jan 21st, 2013

 

Yes to store excel file in data base just you have to save the excel file in .CSV(comma delimiter) format and then insert the value as usually in database.....