[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1239
  • Last Modified:

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?
0
zimmer9
Asked:
zimmer9
  • 2
1 Solution
 
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now