• help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows.I dont have a delimiter. csv file: (First row is blank) apple bat cat doll when i used the below command BULK...

    GIG240 pointsBadges:
  • Auto download a .CSV file from network drive

    to a AS/400 physical file through a cl program? how can I do this?

    UARTJ105 pointsBadges:
  • Creating a CSV file to FTP

    I just loaded Office 2007 and created a csv file which then was FTP'ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

    Superiorsys15 pointsBadges:
  • Code to upload CSV file to AS400

    I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.

    Jazzcafe5 pointsBadges:
  • Importing addresses via .CSV as a new contact group

    I am working on sending out a mass email based on a list of names received as a .csv. I have converted this file to a .wk4 and a .wk1 and I am able to import the names, however, when trying to import the names as a group they appear as seperate contacts. Is there anyway to import all of these names...

    Saylorjr5 pointsBadges:
  • create .csv file from table

    how to create a .csv file which will contain data in 2 or more tables

    Cpp5 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • export to csv file from java app

    In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries...i dont have any knowledge of iseries and we need to deploy our application on iseries ...can anyone tell me how to do the same thing on iseries

    Hn25 pointsBadges:
  • Problems with tranferring flat file from mainframe to Outlook as CSV file

    I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

    Rickb19745 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught'...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS Access conversion to CSV files

    I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the "text 255 cha" values. I need specifically to keep the same properties. I used to be able to do it and is not working now.

    Hsisan5 pointsBadges:
  • Whats a good tool/software to import (excel, csv) into IBM DB2

    Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

    Geyes15 pointsBadges:
  • how to convert a csv file into a xlsx one?

    Hi, i´m genetarting a csv file from an open hub in BW so i need to convert it into a xlsx one due to i need to upload it into the microsoft share point. is there an abap function that does it? i know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • how to import GAL in microsoft exchange 2003 from csv

    how to import GAL in microsoft exchange 2003 from csv

    Yundhi5 pointsBadges:
  • CSV data into Excel 2007

    Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a ":"....

    SHAPOW35 pointsBadges:
  • Flexgrid loading from CSV and saving to CSV

    I am creating database application that will allow the user to enter information into a flexgrid as well as load data from a CSV file into the flexgrid as well as save that file and i have a couple of questions 1, how do i make the application load the data from a specific CSV file 2, how do i make...

    Armageddonash135 pointsBadges:
  • Bad date.

    I'm using the "CPYTOIMPF" to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here's what it looks like.ñññòð÷

    Shelties10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following