Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IMPORT CSV FILE TO SYBASE TABLE

Status
Not open for further replies.

cobolera

Programmer
Nov 16, 2007
1
PR
Is there anyway to import a .csv(or other file) to a SYBASE
table using ISQL?

According to the Sybase SQL Anywhere User's Guide, I can use the
LOAD TABLE command.

I tried this:

load table My_Family from 'c:\\test\\testfile.csv'

and I get the message
Invalid syntax near the keyword table.

 
Sybase SQL Anywhere is a different product from Sybase Adaptive Server, in whose forum you are posting. ASE has no "load table" function. You'd have to load the table using bcp. Which product are you using?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top