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

asked 15 Jun '12, 03:31

munish's gravatar image

munish
30224
accept rate: 0%

edited 18 Jun '12, 07:04

Graeme%20Perrow's gravatar image

Graeme Perrow
8.7k374111

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

(18 Jun '12, 06:12) munish

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

(18 Jun '12, 06:35) Reimer Pods
Replies hidden

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

Thanks, Munish

(18 Jun '12, 06:57) munish
Comment Text Removed

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

...say what? please explain.

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

(18 Jun '12, 08:47) Breck Carter

Thanks for adding the details ...

(18 Jun '12, 10:20) Reimer Pods

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.

permanent link

answered 15 Jun '12, 03:41

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674
accept rate: 33%

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

permanent link

answered 29 Sep '14, 09:03

anonymous's gravatar image

anonymous
0
accept rate: 0%

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

(02 Oct '14, 06:19) Thomas Dueme...

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

(02 Oct '14, 08:03) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13
×13

question asked: 15 Jun '12, 03:31

question was seen: 6,113 times

last updated: 02 Oct '14, 08:03