Search results for query: *

Sorry if this has been covered before, but is there a way to import a CSV file using stored proecedures. We have a nightly routine which updates data into SQL, and part of that routine will require reading from a CSV or TXT file. I'm hoping to use what SQL already has available instead of...

Jim, Yeah, I did try that. It didn't help. Thanks, though.

I am trying to combine a number of text files into one file using Microsoft Access. I am looping through the files and using Input and Output files to read each line and send it to the new file. I am also checking each line to look for certain key tags so that I can only send portions of the...

Thanks, Vepo. That worked like a charm. :-)

wushutwist, Our client is not satisifed with writing the file directly to the server location. If I am writing using Input/Output Streams (which is how I am building the file in the first place) then there would be no reason to copy the file from the local machine to the server.

Sorry. In the above post. The ComUtility class returns the following string: copy C:\\recap.tbl C:\\remote\\recap.tbl

I am having a problem. I am tring to copy a file from one location to another using the Runtime object, but can't seem to get it to work. I keep getting the following error: CreateProcess: copy C:\recap.tbl C:\remote\recap.tbl error=2 Does anyone know what this means? This is the code...