developers

    Forum Stats

  • 3,874,065 Users
  • 2,266,670 Discussions
  • 7,911,715 Comments

Discussions

Loading a CSV file into a table

partlycloudy
partlycloudy Member Posts: 8,176 Silver Trophy
edited Apr 20, 2011 1:46AM in APEX Discussions
HTML DB Data Workshop has a feature to load a CSV file and create a table based on it.

I use a simplified version of this feature in my applications.

See a quick demo at

http://htmldb.oracle.com/pls/otn/f?p=38131:1

Create a small csv file like

col1,col2,col3
varchar2(10),number,"number(10,2)"
cat,2,3.2
dog,99,10.4


The first line in the file are column names
Second line are their datatypes.

Save the file as c:\test.csv
Click the Browse button, search for this file.
Click the Submit button to upload and parse the file.

You can browse the file contents.

If you like what you see, type in a table name and click the Create Table button to create a table.

Let me know if anyone is interested and I can post the code.

Hope this helps.

Message was edited by:
Vikas

Message was edited by:
Vikas
«13456719

Comments

This discussion has been closed.
developers