How could I import an Excel 2010 xlsx file into a Sybase table using DBArtisan 9.1.2 ?

I am working with Sybase using DBArtisan. 9.1.2.

Are there different ways to import an Excel 2010 file into a Sybase table?

If so, what steps would I take to populate a Sybase table with an Excel xlsx file?
zimmer9Asked:
Who is Participating?
 
Joe WoodhousePrincipal ConsultantCommented:
I see from your other question you're running into issues with column names. I was going to suggest the Data Import Wizard if it is important to do this via DBArtisan.

The main issue with delimited data is if the delimiter character(s) appear(s) anywhere in the data itself. If you're certain that no commas appear anywhere then CSV is usually safe.

I personally wouldn't use DBArtisan or any other third party tool for this myself as they all just implement the free built-in Sybase "bcp" utility... so I'd just go direct to that. It's well documented in the (free) Sybase manuals.
0
 
Joe WoodhousePrincipal ConsultantCommented:
Which Sybase product? They have several database products and the answer would be different for each.
0
 
zimmer9Author Commented:
Ase Client with version 15.0.2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.