You mean to say that every time we get excel input file we must do a save as in csv format. Can it be done in any other way any suggestions.Loveojha:
That won't convert it to csv, go to your xls editor, do a save as and save it as a csv file format.
Unable to open csv file format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 66
- Joined: Fri Nov 25, 2005 7:55 am
Yes exactly.You mean to say that every time we get excel input file we must do a save as in csv format. Can it be done in any other way any suggestions.
The other thing could be using the excel file through a DSN created of the workbook, using microsoft's drivers.
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 66
- Joined: Fri Nov 25, 2005 7:55 am
Just for one last note - no, you didn't. Double-clicking on the renamed csv file simply launched Excel and you were looking at the spreadsheet. Again.vijayindukuri wrote:After renaming the file i tried to view the file by double cliking that,I was able to see that data in csv format.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
There are softwares present out-there that can do the conversion for you. Renaming the file doesnt change its structure internally. As your OS is windows, you can access the workbooks by creating an odbc connection.
Regards,
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
If the incoming excel file has only one sheet, no extra blank sheets and there are no special formatting. Then, you might be able to open it using sql file stage with delimiter as 009 (tab). Some times you would have to specify the file format as Dos if your ftp process doesnt take care of converting CRLF ---> Lf.
thank you,
a novice
thank you,
a novice
Vijay indukuri,
I had the same problem while having source system as MS Access. What I did was i wrote an update statement to eliminate the newline carriage
UPDATE OPP_12JUNE SET BAMNOTES = replace(OPP_12JUNE.BAMNOTES,Chr$(10),'');
then i have exported to a location(say to the desktop for instance) then made it tab delimited and set other delimitres as none.
if am not wrong same should work for you. Reason is that even though you made the file tab delimited, it may still have some "Enter"(new line carriage) characters present. so first update the table the export as a tab delimited file.
I had the same problem while having source system as MS Access. What I did was i wrote an update statement to eliminate the newline carriage
UPDATE OPP_12JUNE SET BAMNOTES = replace(OPP_12JUNE.BAMNOTES,Chr$(10),'');
then i have exported to a location(say to the desktop for instance) then made it tab delimited and set other delimitres as none.
if am not wrong same should work for you. Reason is that even though you made the file tab delimited, it may still have some "Enter"(new line carriage) characters present. so first update the table the export as a tab delimited file.