1. Create table in the database which you want to use to hold the content in the excel file using create table command. For simple you can create a table with exactly same field name as in the excel file.
2. delete the field names from the excel file if there is any.
3. Save the excel into CVS (Comma separated file) file.
4. use the copy command to transfer data from CVS file into database.
copy table_name from 'source_file_with_path' DELIMITERS ',' CSV;
for example,
copy student_19 from 'E://ftproot//Student_19.csv' DELIMITERS ',' CSV;
Subscribe to:
Post Comments (Atom)
Datatable static image not found on the server
When you use ```datatables.min.css``` and ```datatables.min.js``` locally, instead of datatables CDN, you may have encountered that ```sort...
-
1. locate where is suexec by running the following: whereis suexec return suexec: /usr/sbin/suexec /usr/share/man/man8/suexec.8.gz 2. rename...
-
Case One The following procedure is good if you have admin account for Internal workspace. 1. Log into Internal workspace with admin accou...
-
Step 1. Install Oracle XE 11g 1. Download Oracle XE (oracle-xe-11.2.0-1.0.x86_64.rpm.zip) from Oracle official website. You need an accoun...
No comments:
Post a Comment