• CSV to Access

    I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?

    Vvaidya5 pointsBadges:
  • convert csv file to pf file

    i have a file on IFS in .csv format.how to copy this file to pf format in another library.

    Kapiltiwari350 pointsBadges:
  • Open XL file from ILE program

    We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

    filuphaze475 pointsBadges:
  • Need a 3rd party AS/400 utility for converting to .CSV files

    Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. The...

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

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

    UARTJ235 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 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:
  • 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 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 ":"....

    SHAPOW45 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.

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

Following