Import Excel File to Sybase Database Table

[Former Member]

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:- [email protected]

[Former Member]

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

[reimer_pods]

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).

[Former Member]

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

Thanks, Munish

[Breck_Carter]

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

...say what? please explain.

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

[reimer_pods]

Thanks for adding the details ...

[VolkerBarth]

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.

[Former Member]

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

[thomas_duemesnil]

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

[Breck_Carter]

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