CODEWITHSUNDEEP
excelsybaseoracle-sqldeveloper
Satyendra
Satyendra

Reputation: 1705

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

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 ?

Upvotes: 1

Views: 10580

Answers (2)

Gopal Sanodiy
Gopal Sanodiy

Reputation: 91

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

Upvotes: 2

Boggio
Boggio

Reputation: 1148

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:

  1. If you use "Sybase SQL Anywhere" check the documentation for "load table" statement, it also supports loading Excel files.
  2. Use Interactive SQL client from Sybase to upload you excel file.
  3. Use the "INPUT" statement inside Interactive SQL.
  4. 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.

Upvotes: 2

Related Questions