Question Re: Import Excel File to Sybase Database Table in Technology Q&A

Import Excel File to Sybase Database Table

Former Member — Fri, 15 Jun 2012 03:31:48 GMT

I have to import excel file in sybase database table. I have googled this, but i can't import file on the table.

Please anyone can help me. You can reply me on following email id:- munish@deftsoft.com

Re: Import Excel File to Sybase Database Table

VolkerBarth — Fri, 15 Jun 2012 03:41:55 GMT

You may have a look at that FAQ for an "programmable solution".

For a manual import, you might choose the "Import Wizard" in Interactive SQL.

Re: Import Excel File to Sybase Database Table

Former Member — Mon, 18 Jun 2012 06:12:30 GMT

Hello, I am try to import excel file by manually from "Import Wizard", but when i import excel file, it gave an error :- "Could not import E:test.xls. The file may be in an unsupported format, or it could be corrupt."

Please give me a solution ASP.

Thanks, Munish

Re: Import Excel File to Sybase Database Table

reimer_pods — Mon, 18 Jun 2012 06:35:27 GMT

What SA version are you using? A direct import from Excel files is not possible with SA11 and higher.

If you export the content of the XLS file as a text file (CSV), the import wizard should handle that.

Alternativeley take a look at Volker's response (FAQ).

Re: Import Excel File to Sybase Database Table

Former Member — Mon, 18 Jun 2012 06:57:01 GMT

I am using SA 10 .So in SA10 ,is there any possibility of importing excel file to sybase database table?

Thanks, Munish

Re: Import Excel File to Sybase Database Table

Breck_Carter — Mon, 18 Jun 2012 08:47:52 GMT

"A direct import from Excel files is not possible with SA11 and higher."

...say what? please explain.

Oh, you mean dbisql - Data - Import...

Re: Import Excel File to Sybase Database Table

reimer_pods — Mon, 18 Jun 2012 10:20:31 GMT

Thanks for adding the details ...

Re: Import Excel File to Sybase Database Table

Former Member — Mon, 29 Sep 2014 09:03:02 GMT

i want to import a text file in an existing table how can i import it using this import tab in sybase as it is giving an error of having primary key as my records in text file have records with same primary key value with different data in other records can anyone help me ?? as soon as possible

Re: Import Excel File to Sybase Database Table

thomas_duemesnil — Thu, 02 Oct 2014 06:19:32 GMT

Import you stuff in a temporary table and create a procedure/script that takes care of your duplicate primary key problem. You can not expect from a import engine to solve this for you.

HTH

Re: Import Excel File to Sybase Database Table

Breck_Carter — Thu, 02 Oct 2014 08:03:43 GMT

@anonymous: Please post a new question as a question, not an answer to an existing question... use the "ask a question" button.