How to import data from "excel" to "sybase table" using sql developer?

Question

I have connections for both 'oracle' and 'sybase' in my 'Sql Developer'.

For the Oracle-Connections there are options to import data from excel, csv, dsv, etc...
While, for the Sybase-Connections I can't find any import option.

Is there any way to import data from excel file to tables in sybase ?

What kind of Sybase database are you connecting to? ASE? SQL Anywhere? Please be more specific when asking questions, it will help. — Mike Gardner
– Mike Gardner, Commented Nov 5, 2013 at 14:25

Boggio · Accepted Answer · 2013-11-05 12:27:59Z

2

I have never used SQL developer with Sybase before, I'm not sure it's officially supported. This might also be the reason why the context menu (import from excel) is unavailable. Possible solutions for your problem:

If you use "Sybase SQL Anywhere" check the documentation for "load table" statement, it also supports loading Excel files.
Use Interactive SQL client from Sybase to upload you excel file.
Use the "INPUT" statement inside Interactive SQL.
Export the excel document into a CSV format and load it using the "load table" statement.

I would recommend exporting to a CSV format and then importing into the Database, just be careful with the output from excel to CSV.

answered Nov 5, 2013 at 12:27

Boggio

1,14811 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Satyendra Over a year ago

Sql Developer supports to the sybase connections when used with third-party-driver (jtds)

Mike Gardner Over a year ago

While the connection may be supported, not all the features may be the same. I agree with Bogdan, you may have to extract the data and load it with Sybase tools.

Gopal Sanodiy · Accepted Answer · 2013-11-11 12:01:00Z

2

Save Excel in CVS format and then bcp in the file:-

bcp dabase_name..Table_name in filename -Uuser_name -Ppswd -SServerName -c -t "," -Y

answered Nov 11, 2013 at 12:01

Gopal Sanodiy

912 bronze badges

1 Comment

Burcin Over a year ago

This is also good way (with native bulk copy tool... If you get problems its possible to verbose error.

Collectives™ on Stack Overflow

How to import data from "excel" to "sybase table" using sql developer?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related