Re: Can't Select External Table from CSV File

Yes, all of my client using the same mechanism to copy their file to central. They using dial-up to connect RAS to open the network folder (folder at file server) and then copy all files. That process is done with the Excel Macro, the user only input the username & password. And then with the Oracle Job, we find the files, open it through external table and then insert data to production table. How could I found the CRLF in that files? What editor can I use?

Thank you very much

joel garry wrote:
> Resant wrote:
> > I don't think so, because they use the same application.
> > So they will create CSV file in the same mechanism. I think must be
> > external factor - like Excel version (but I've already check that they
> > have same version) or something else - that could be one of the cause.
> > I can't think other, any other idea please?
> >
>
> But are they moving the file around with the same mechanism? If they
> are ftp'ing, that could do the CRLF thing (binary v. ascii file copies
> between OS's is the usual issue - look at the files with an editor that
> doesn't hide these things from you).
>
> It might really help us help you if you stated versions and platforms
> and such. "Central database" could mean a lot of things.
>
> jg
> --
> @home.com is bogus.
> http://photos.signonsandiego.com/gallery1.5/signon
Received on Mon Jul 24 2006 - 21:51:42 CDT