Tab-delimited with format file  Copying in data with field lengths

Chapter 4: Using bcp to Transfer Data to and from Adaptive Server

Examples: copying in data interactively

To copy in data successfully to a table from a file, you must know what the terminators in the file are or what the field lengths are and specify them when you use bcp.

The following examples show how to copy data in, either with fixed field lengths or with delimiters, using bcp with or without a format file.





Copyright © 2005. Sybase Inc. All rights reserved. Copying in data with field lengths

View this book as PDF