create database table based on Excel spreadsheet

hi i have a excell spreadsheet which got about 25 rows how can i create database table based on this spreadsheet am in oracle database 11gR2 am using pl/sql developer IDE
chalie001Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
create table some_table (col1 char(1), col2 char(1));

Just add the additional columns and correct data types.


Are you asking how to do this dynamically through VBA?
Gerwin Jansen, EE MVETopic Advisor Commented:
You use the Import Data wizard for that.

Open a connection to your db and right-click 'Tables', choose 'Import Data' and Browse to your Excel sheet,follow the wizard.
chalie001Author Commented:
imptfile
hi am not able to see import data i what to create a table without writing excell spreadsheet with 50 columns
Need More Insight Into What’s Killing Your Network

Flow data analysis from SolarWinds NetFlow Traffic Analyzer (NTA), along with Network Performance Monitor (NPM), can give you deeper visibility into your network’s traffic.

chalie001Author Commented:
sql developer
i have excell spreadsheet wth 50 columns how can i create new table with those spreadsheet columns without writing script thats what i need i don't what to do import data
chalie001Author Commented:
how can i do this  dynamically through VBA? if it can do this for me
Gerwin Jansen, EE MVETopic Advisor Commented:
Which sql developer version are you using? I'm using Oracle SQL Developer 4.x and I have the import function here:
import

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
>> without writing script thats what i need i don't what to do import data

You do realize that with notepad you could have had this done and the table created a long time ago...  and done correctly.

Wizards are all great and wonderful but they will still have to "guess" at column data types.

What if it creates the table as varchar2(10) but you really need varchar2(50)?
slightwv (䄆 Netminder) Commented:
>>how can i do this  dynamically through VBA? if it can do this for me

You would rather write VBA code than open up notepad and type out the CREATE TABLE syntax?  Seems like A LOT more work.

If the spreadsheet has a header row, notepad is a lot easier, copy/paste the header row and you have the column names (after 'fixing' the spaces in the names).  then some quick copy/paste for the data types and you are pretty much 90% done.
Gerwin Jansen, EE MVETopic Advisor Commented:
>> how can i do this  dynamically through VBA? if it can do this for me
How exactly do you want this done through VBA? About your SQL Developer, I think you have an older version, which version do you have?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.