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...
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...
5 pts.
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 ...
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 ...
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.
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.
concatenate more than 2 fields together into one field in SQL
say I have 3 columns, 1st name, midlle name and last name, how do I merge the 3 columns into one column yet separate the content with commas
say I have 3 columns, 1st name, midlle name and last name, how do I merge the 3 columns into one column yet separate the content with commas
Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...
We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...
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
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
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
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
how to import GAL in microsoft exchange 2003 from csv
how to import GAL in microsoft exchange 2003 from csv
how to import GAL in microsoft exchange 2003 from csv
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...
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...
Export to CSV or dump file
can any body guide how to export from command line in oracle 10g tables or db to CSV or dump file.
can any body guide how to export from command line in oracle 10g tables or db to CSV or dump file.
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...
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...
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.ñññòð÷
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.ñññòð÷
