There is still a lack of possibilities to create a table from scratch from a csv (with 1 line contains the column names).

The best method so far i found is:

1. Import csv into an access db (yes i know, but until you guys come up with a better idea).
Here you will have an access table with column names and datatypes (and your data)

2. Export this table by usng export => into an ODBC DB (which is your Oracle DB)

3. connect and you’ll have your Oracle table, with columns, datatypes and data

Quite easy and fast, if somebody has a better and faster idea (by not passing by an access db), let me know.

This entry was posted on Monday, February 15th, 2010 @ 2:49 am on the category Migration/Import. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.